Тёмный

Part 4: SQL Query Interview Questions & Answers | Find Nth highest Salary (Co-related Sub Query) 

SDET- QA
Подписаться 730 тыс.
Просмотров 48 тыс.
50% 1

SQL Query Interview Questions & Answers
--------------------------------------------------------------------
Topics:
------------
1) Find Nth highest Salary (Co-related Sub Query)
2) How To Find 2nd, 3rd...Nth highest Salary using Co-related Sub Query (without using max(), limit & top)
#########################
Udemy Courses:
#########################
Manual Testing+Agile with Jira Tool
************************************
► shorturl.at/xNXZ4
Selenium with Java+Cucumber
********************************
► shorturl.at/aIKMW
Selenium with Python & PyTest
********************************
► shorturl.at/ELW09
Selenium with python using Robot framework
****************************************
► shorturl.at/bcDPZ
API Testing(Postman, RestAssured & SoapUI)
*****************************************
► shorturl.at/uAWY7
Web & API Automation using Cypress with Javascript
********************************************
► rb.gy/4uum2n
Playwright with Javascript
**************************
► shorturl.at/gALZ1
Jmeter-Performance Testing
************************
► rb.gy/ocj7r2
SDET Essencials(Full Stack QA)
*************************
► rb.gy/hlnf2v
Appium-Mobile Automation Testing
************************************
► rb.gy/wmzv64
Java Collections
*****************
► bit.ly/3S66ezE
Python Programming
*********************
► urlis.net/gdsf...
Cucumber BDD Framework
***************************
► bit.ly/3F7d69r
Protractor with Javascript
***************************
► urlis.net/4udd...
####################################
RU-vid Playlists:
####################################
Manual Testing & Agile
***********************
► bit.ly/3ujvaYa
► bit.ly/3OYzxQj
SQL
*************************
► bit.ly/3R6XjeG
► bit.ly/3nE0a1s
► bit.ly/3IeKuuJ
linux & Shell Scripting
**********************
► bit.ly/3up1Z6a
► bit.ly/3nzvGxx
Java
**********************
► bit.ly/3R9QfOs
► bit.ly/3AoRMKM
► bit.ly/3IbTTDn
► bit.ly/3ybXInv
► bit.ly/3yCoHdw
Selenium With Java+Cucumber
********************************
► bit.ly/3P2FMm4
► bit.ly/3yhiIt4
► bit.ly/3uokzet
► bit.ly/3a7XIND
► bit.ly/3umN2S9
► bit.ly/3aar7GW
► bit.ly/3y9kD2S
► bit.ly/3uhLskn
Python
********************
► bit.ly/3agNgU0
► bit.ly/3NJNnoy
► bit.ly/2CTQ4mR
► bit.ly/3OIYWh1
Selenium With Python,Pytest&Behave
***************************************
► bit.ly/3OHHoC9
► bit.ly/3IeNLdv
► bit.ly/2J4tPeT
► bit.ly/3ydSkAq
Selenium With Python Using Robert Framework
(Web&API Testing)
*************************************************
► bit.ly/3nUvlpr
► bit.ly/3nUvE3z
API Testing (Postman,SoapUi,&Rest Assured)
**********************************************
► bit.ly/3OXacWY
► bit.ly/3yh0UhE
► bit.ly/3nC9DWQ
► bit.ly/3yGfhNS
► bit.ly/3OJa11H
► bit.ly/3P2slCC
Mobile App Testing Appium
****************************
► bit.ly/3Al49HG
Performance Testing Jmeter
*******************************
► bit.ly/3nz4fE7
Maven,Jenkins,Git,Github,CI/CD
*******************************
► bit.ly/3P16HPj
► bit.ly/3yhlUVA
► bit.ly/3afYfwT
► bit.ly/3yGzweG
► bit.ly/3yF73Ws
► bit.ly/3NCOmH7
SQL,DB Testing&ETL,Bigdata
*******************************
► bit.ly/3NKOcNY
► bit.ly/3OVpDyI
► bit.ly/3NEvUy0
► bit.ly/3IryxlT
► bit.ly/3RkWBLh
JavaScript Based Automation Tools
********************************
► bit.ly/3nUx51X
► bit.ly/3AqI6Q0
► bit.ly/3yeurbT
► bit.ly/3ujzpTK
Selector Hub Tools
********************
►rb.gy/h3h424
GraphQL
*********
► rb.gy/sj3gys
Cypress API Testing
*******************
► shorturl.at/fjKPX
Cypress Web Testing
********************
► shorturl.at/agjlK
Playwright with Javascipt
************************
► shorturl.at/adSTY
#SQLInterviewQuestions
#SQLQuery
#NthHighestSalary
#CorrelatedSubquery
#InterviewPrep
#DatabaseManagement
#SQLTips
#DataManipulation
#SQLPerformance
#CodingInterview
#SQLChallenges
#QueryOptimization
#TechInterview
#SQLTricks
#SubqueryExamples
#AdvancedSQL
#CodingSolutions
#DatabaseQueries
#DataAnalysis
#InterviewSkills
#SQLProblems
#SubqueryUsage
#SQLDeveloper
#ProblemSolving
#DatabaseDesign
#InterviewPreparation
#SQLOptimization
#SubqueryTricks
#DataQueries
#TechTips
#SQLFunctions
#CodingProblems
#DatabaseSkills
#QueryWriting
#InterviewAnswers
#SQLPuzzles
#SubqueryPerformance
#DataManipulationSkills
#TechSolutions
#SQLCoding
#QueryExamples
#InterviewSuccess
#SQLHacks
#SubqueryBestPractices
#DataRetrieval
#TechTricks
#SQLPractice
#QueryOptimizationTips
#InterviewTips
#SQLCodingChallenge

Опубликовано:

 

29 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 31   
@mathematicscbsc
@mathematicscbsc 6 месяцев назад
Sir you are GOD OF TESTING DOMAIN PLEASE CONTINUE YOUR WORK
@archanak1639
@archanak1639 5 месяцев назад
Bcoz of You I am easily understand all that stuff 🥰
@sravanisandhyapogula9996
@sravanisandhyapogula9996 2 года назад
Your teaching is so good it is easily understand to all ,But please upload new series for selenium automation,it helps so much for us.previous videos are very long back .
@SabrinaY-q5p
@SabrinaY-q5p Год назад
Wow, such hard to understand idea was explained so clearly. Thank you!
@sdetpavan
@sdetpavan Год назад
Welcome
@aviksarkar8673
@aviksarkar8673 Год назад
Just to add a bit ... If the input is given as -------------------- id Salary 1 - 100 2 - 100 ------------------- N = 1 ------------------ Sir's query will be showing 2 rows. To avoid that - Just add a "distinct" keyword after the first SELECT statement. The updated query will be the following - SELECT DISTINCT salary FROM Employee e1 WHERE N - 1 = ( SELECT COUNT(DISTINCT salary) FROM Employee e2 WHERE e2.salary > e1.salary )
@lifestyleworld6821
@lifestyleworld6821 11 месяцев назад
Wonderful sir 👏. Thanks you so much.
@sdetpavan
@sdetpavan 11 месяцев назад
You are most welcome
@pannagabm2100
@pannagabm2100 11 месяцев назад
Thank you so much sir.. ❤
@sdetpavan
@sdetpavan 11 месяцев назад
Most welcome
@jadhavjyoti3293
@jadhavjyoti3293 2 года назад
im having trouble, query with rand function not working in oracle database. Need to select only one random Customerid every time. eg.. select Customerid from mastertable where custtype=savingaccount and Customerid 80000 order by rand(); pls suggest solution. i tried multiple way, every time showing error, rand() invalid identifier.
@jagadeeshkumar9745
@jagadeeshkumar9745 2 года назад
short and neat video on finding nth highest salary. thanks a lot
@sdetpavan
@sdetpavan 2 года назад
Most welcome!
@shanusingh6278
@shanusingh6278 2 года назад
great method to find the nth salary I wrote a query very easy to find nth salary so please consider it select min(salary) from (select distinct salary from employee order by salary desc limit 3) as emp;
@sureshisoft4555
@sureshisoft4555 2 года назад
You are Great Trainer...Thanks Pavan...
@sdetpavan
@sdetpavan 2 года назад
welcome
@chetankarale8552
@chetankarale8552 2 года назад
ITS TOO GOOD SIR UR TEACHING IS VERY NICE
@sdetpavan
@sdetpavan 2 года назад
Keep watching
@anshuljain216
@anshuljain216 Год назад
Vry nice teaching sir
@sdetpavan
@sdetpavan Год назад
Thanks
@dineshkarthik6072
@dineshkarthik6072 2 года назад
Hi sir i have done MBA background completely non technical so is it possible get job software testing....?
@PastEventsTV
@PastEventsTV 2 года назад
Yes u can get..if possible do a software testing course mainly of 6 months
@octotube463
@octotube463 2 года назад
Wow! Never gave a thought on using correlated query for Nth Salary. Thank you! Btw, I would suggest distinct after Select so that you get only one row when we have same salaries for multiple employees. In this example when N =3 , we will get two records with 2000 ( Data from the white board) and distinct will solve the issue.
@sdetpavan
@sdetpavan 2 года назад
Noted
@madhavikatta7346
@madhavikatta7346 2 года назад
Sir please upload more vedios
@narendrakanala1313
@narendrakanala1313 Год назад
3rd highest 2000
@rajatmukkawar3440
@rajatmukkawar3440 2 года назад
❤️🔥
@terabyte289
@terabyte289 2 года назад
👍
@PastEventsTV
@PastEventsTV 2 года назад
Sorry sir , I am asking in wrong video..today I had an interview which went well, but one question I have doubt for. The question : If the end point is given wrong for api , what status code will return in response? I Said him 404 ..was it right pls confirm?
@aviksarkar8673
@aviksarkar8673 Год назад
Correct
Далее
Новый вид животных Supertype
00:59
Просмотров 232 тыс.
Это нужно попробовать
00:42
Просмотров 396 тыс.
Part1: SQL Query Interview Questions & Answers
17:57
Просмотров 264 тыс.
Part2: SQL Query Interview Questions & Answers
26:13
Просмотров 110 тыс.
Practice SQL Interview Query | Big 4 Interview Question
14:47
Новый вид животных Supertype
00:59
Просмотров 232 тыс.