Part2: SQL Query Interview Questions & Answers

Topic : SQL Query Interview Questions & Answers

#########################
Udemy Courses:
#########################

Manual Testing+Agile with Jira Tool
************************************

Selenium with Java+Cucumber
********************************

Selenium with Python & PyTest
********************************

Selenium with python using Robot framework
****************************************

API Testing(Postman, RestAssured & SoapUI)
*****************************************

Web & API Automation using Cypress with Javascript
********************************************

Playwright with Javascript
**************************

Jmeter-Performance Testing
************************

SDET Essencials(Full Stack QA)
*************************

Appium-Mobile Automation Testing
************************************

Java Collections
*****************

Python Programming
*********************

Cucumber BDD Framework
***************************

Protractor with Javascript
***************************

####################################
Youtube Playlists:
####################################

Manual Testing & Agile
***********************

SQL
*************************

linux & Shell Scripting
**********************

Java
**********************

Selenium With Java+Cucumber
********************************

Python
********************************

Selenium With Python,Pytest&Behave
***************************************

Selenium With Python Using Robert Framework
(Web&API Testing)
*************************************************

API Testing (Postman,SoapUi,&Rest Assured)
**********************************************

Mobile App Testing Appium
****************************

Performance Testing Jmeter
*******************************

Maven,Jenkins,Git,Github,CI/CD
*******************************

SQL,DB Testing&ETL,Bigdata
*******************************

JavaScript Based Automation Tools
********************************

Selector Hub Tools
********************

GraphQL
******************

Cypress API Testing
********************

Cypress Web Testing
**********************

Playwright with Javascipt
**************************
#SQLInterview
#SQLQuery
#SQLQuestions
#SQLAnswers
#SQLCoding
#SQLChallenges
#SQLPuzzles
#SQLExpert
#SQLSkills
#SQLTips
#SQLTricks
#SQLSolutions
#SQLExercises
#SQLDeveloper
#DatabaseInterview
#DatabaseQuestions
#DatabaseAnswers
#SQLServerInterview
#MySQLInterview
#OracleInterview
#PostgreSQLInterview
#DBMSInterview
#DataAnalysisInterview
#DataManipulation
#DataQuery
#SQLPerformance
#SQLNormalization
#SQLJoins
#SQLSubqueries
#SQLGroupBy
#SQLAggregations
#SQLViews
#SQLIndexes
#SQLTransactions
#SQLConstraints
#SQLOptimization
#SQLStoredProcedures
#SQLFunctions
#SQLDataTypes
#SQLDataModeling
#SQLInterviewPrep
#SQLInterviewTips
#SQLQueryTuning
#SQLQueryExamples
#SQLQueryProblems
#SQLInterviewSuccess
#SQLInterviewSkills
#SQLQueryLanguage
#SQLQuiz
#SQLInterviewSeries

[jagadeeshkumar]

till now i thought we can join the tables only by using joins but you explained it using sub query. easy to understand concepts. thanks a lot

[ravirajvhetam]

Q.no. 19-
salary = salary + (salary*(10/100))
In order to update salary by 10%.
Surely it was done by mistake.🙂

[divyasundaram]

Your way of teaching is excellent sir, you are making us to understand the concepts very well ...thanks a lot...keep doing it ever sir...

[nirajjha]

Your teaching style is very excellent and conceptual.
Can u share the latest step by step selenium video.. Either how can i join the your selenium batch from scratch ..

[varshasharma-xszl]

Sir in question 19 it should be salary = salary+ (salary*10/100)

[robertovermier]

You need to make a correction to the table id in Ques.18 where you specify "Location_Id" as the table name where it should be just "Location". Also correct Ques. 19 the word "where" in the query sample. Very good examples of the various query formats!

[Peace-mxrz]

i thought we can join tables only using joins OMG thank you so much !

[nsnreddy]

Hi Sir, on 19th question, they are asking update managers salary is 10%,

I think the query is on where condition is:

WHERE salary= salary+(salary*10/100)

Am i correct sir?

[Avadhut-ndyz]

Q. 19 set salary = salary + salary*10/100

[nirajjha]

Sir in 19 question.
U use formula salary = salary*10/100
Suppose deptid =20 whose salary 800
Using above formula we got 80 only, and it wl be updated 80 only instead of total. 880
Can we use here set salary = salary+salary*10/100.
I wl wt ur answer sir.. 🙏

[scrapyscrapy]

Perfect explanation with perfect tone... 🙏 God bless you more

[lokeshkumarverma]

Sir. Thank you for all your efforts. please make a video for rest API interview questions with postman.

[muhammadzaakirmungrue]

Thanks for showing the tables, the question and the answer one one slide 😊

[priyankagupta-siho]

Thanku Sir for your wonderful Support.

[harishankar]

Question 17, 18 we can use join it's much easier.

[francodsouza]

For interviews, is this approach valid or we have to go via joins? I find this better than Joins tbh

[rajprajapati]

thank you so much sir.
.
This questions are very helpful. 😊

[rainbowplayz]

thank u so much Sir..i understand each concept by using sub queries

[irfansayani]

ques 19 ans is -> update Employee set salary =salary*1.1 where job_id=(select job_id from job where function='MANAGER' oR
update Employee set salary =salary*110/100 where job_id=(select job_id from job where function='MANAGER'

[janakiyeluripati]

@8.59, Q16. Is this correct for getting department wise max salary?
select emp_id, salary, dep_id from Employee group by dep_id having Max(salary)