Find Nth Highest Salary in SQL | 5 Different Ways | Most Important SQL Interview Question

In this video we will see how we can find the Nth (1st, 2nd , 3rd, ... ,nth) Highest salary in SQL . Here we will discuss five different ways to solve this query .
✅Using Max() - 1:15
✅Using LIMIT - 3:15
✅Without using LIMIT - 5:42
✅Using dense_rank() - 8:27
✅Using NOT IN operator - 11:10
Join our Telegram Channel - t.me/joingroupCodeEra
⭐Part 1:Top 9 SQL queries for interview -
• Top 9 SQL queries for ...
⭐Part 2:Top 9 SQL queries for interview -
• PART 2 : Top 9 SQL que...
⭐Top SQL Interview Question
• Top SQL Interview Ques...
⭐Types of Joins in SQL-
• SQL Joins & Its Types ...
⭐Aggregate Functions In SQL | COUNT, SUM, AVG, MIN, MAX | IFNULL( )
• Aggregate Functions In...
⭐Difference Between DELETE, DROP and TRUNCATE
• Difference Between DEL...
⭐SQL vs NoSQL | MySQL vs MongoDB
• Difference between SQL...
⭐DBMS vs RDMS
• DBMS vs RDBMS | What i...
⭐Normalization in DBMS-
• Normalization and its ...
⭐Types of key in DBMS-
• Types of Keys in DBMS ...
⭐Create MySQL Database and Table -
• How to Create Database...
#mysql #oracle #dbms #query #top #sqlserver #database #PlacementPreparation

[@saadanwar7914]

The best video out there on this topic, must watch before the interviews

[@imamhasan9942]

Easy, Simple and best way of example, Thanks 👍

[@osoriomatucurane9511]

Awesome tutorial, concise and crystal clear. Well done! At the end, I would go for the one that works all the time, preferably the one that fecthes all the records that meet the specified condition/restriction.

[@bobsva98]

Now my doubt has been cleared, thank you

[@user-lf6lg5yg7e]

finally my doubt cleared in simple way very thanks hope you upload this kind of videos which are helpful

[@souvikghosh7872]

But in Oracle SQL if we use ROWNUM instead of Limit then the order by clause needs to be in a inner query. Otherwise it throws an error.

[@dehumanizer668]

Amazing explanation of all the techniques. Thank you!! 😊👍🏻

[@sunilachaarya6678]

Thank you so much 🙏for this well explained session. 🙌

[@UtkarshSinhas]

You helped me in clearing my interview 🤠 Thank you so much

[@CodeEra2020]

Congratulations.we are so happy that our video helped you.

[@Cake-bz5bf]

Kitne ki package lagi bhaiya😮

[@mohansaivelagapudi929]

Very useful vedio Thanks a lot

[@RaviTejaMeruva]

Excellent Explanation

[@RupeshYadav-kt5dv]

Excellent job ma'am 👏 👍 👌 🙌
Thanks 🙏 🙏 🙏

[@gagandeep8710]

Can you plzz tell .. Is there any approach which is used to find nth salary using MAX function

[@shameenabanu2433]

As 2nd highest is 3lakh and has two employees same salary using normal max function only one row it return the output or two row?

[@Wundex]

thank you. God bless

[@rajdeepsinghborana2409]

Informative ❤️

[@radhasakhi4546]

Nice. , good video

[@poojam271]

Thank You so much Mam

[@ishatawade]

Why use N-1 expression is used? How did you come to that expression? Is it as we doing a binary search?

[@rohitbhosale4614]

thanks please bring videos on python basic problems

[@pradnyavelapurkar9905]

If we use LIMIT function in oracle sql developer it shows error as sql command not properly ended. What to do for that?

[@sandeeptripurana4496]

Good one

[@shraddhadhakad1154]

Awesome 😊

[@govindkota1026]

when we use limit function in oracle it throws error.

[@zulminanahmed9489]

Thanks Ma'am

[@prajakta_subramanian9909]

u r brilliant

[@vdharman1272]

Thanks

[@ArifKhan-qo9jw]

Is this will be work in SSMS?

[@shreyasawankar7601]

Great video 🙏🏻

[@CodeEra2020]

Thank you so much😊

[@AshiiStories]

Hii.. Can you find Nth rank in Department wise please

[@AmitGupta-fd3zy]

thank you mam, you taught very well

[@CodeEra2020]

Please Share with your friends.

[@AmitGupta-fd3zy]

@@CodeEra2020 sure

[@satyabhau69]

Using Limit and Dense Rank is the Correct Approach to get the nth highest numeric value

[@CodeEra2020]

Thanks for watching..

[@nakulanand2725]

Thanks for the info

[@CodeEra2020]

Welcome.

[@arunsinghrajpoot5363]

Please clear in limit if we have multiple rows then.

[@ankitac4994]

very helpful!!!!!!!!!!

[@CodeEra2020]

Thank you so much.

[@khushbooparashar2556]

Good explanation

[@CodeEra2020]

Thank you so much

[@MacTechcom]

nice explaination

[@CodeEra2020]

Keep watching

[@palakmahajan9999]

Nice 👍

[@CodeEra2020]

Thank you so much

[@joelesthak2551]

Superb

[@CodeEra2020]

Thank you so much😊

[@jaymahajan3871]

Good

[@CodeEra2020]

Thank you

[@DileepKumar-kc4qj]

limit clause not working in sql server and without limit clause you solved that i didnt understand can you explain in more so that i can understand i watched many time this video but not clear concept ,,,....thanks in advance CodeEra

[@CodeEra2020]

Please watch this video th-cam.com/video/2QCUQhihwDM/w-d-xo.html . here you will find alternate options for Limit clause

[@unknown_fact1586]

you can use top instead of limit in sql server

[@harshithaharshi1175]

We can use exist and not exist

[@manishranjan571]

2:51,, you query is not working

[@husainasaifee4969]

Upload more👍

[@chetansati5406]

Pls upload more cases

[@CodeEra2020]

Could you please mention which cases do you want to see?

[@pawan8154]

limit do not work in Oracle what is the option
?

[@CodeEra2020]

You can use TOP in Oracle

[@himanshumaggu6562]

When I use limit and top get error sql command not properly ended.How I fix it

[@wasimmomin3851]

Does limit function work in MS SQL server platform?

[@SurendraYadav_]

Nope

[@ankurdixit89]

No..you can use TOP instead of limit in ms sql

[@amolgirase2332]

Select salary
From employee_info E1
Where 3=
(Select count(distinct salary)
From employee_info e2
Where e2.salary >= e1.salary)

[@nawabigaming5301]

Limit function not work in my sql

[@CodeEra2020]

NO
It is working fine in MYSQL

[@user-yy1dw5bc8y]

@@CodeEra2020 not working in sql server?

[@bibhukalyanpatra3525]

LIMIT NOT WORK