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

[@saadanwar7914]

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

[@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😮

[@imamhasan9942]

Easy, Simple and best way of example, Thanks 👍

[@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.

[@gaurabsharma2728]

A very clear and precise explanation of the problem statement. Nice work 👏👏👏

[@Rocky-t4c]

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

[@bobsva98]

Now my doubt has been cleared, thank you

[@ShaniyaMasih]

best explanation till now/ like a sum up ... nice !! thank you:)

[@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.

[@pradnyavelapurkar9905]

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

[@sunilachaarya6678]

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

[@dehumanizer668]

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

[@satyabhau69]

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

[@CodeEra2020]

Thanks for watching..

[@RupeshYadav-kt5dv]

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

[@Wanderingwonders108]

mam mere me to jab mai order by salary desc ka use kar raha hu to null value top par aa rahe ha

[@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?

[@arupanandabehera1527]

thank you so much for your valuable time

[@Wundex]

thank you. God bless

[@RaviTejaMeruva]

Excellent Explanation

[@PankajSingh0943]

Very informative video

[@mohansaivelagapudi929]

Very useful vedio Thanks a lot

[@AmitGupta-fd3zy]

thank you mam, you taught very well

[@CodeEra2020]

Please Share with your friends.

[@AmitGupta-fd3zy]

@@CodeEra2020 sure

[@shreyasawankar7601]

Great video 🙏🏻

[@CodeEra2020]

Thank you so much😊

[@zulminanahmed9489]

Thanks Ma'am

[@CricketGalli]

Using limit clause can we find 4th and 5th salary ? Pls confirm

[@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 kzbin.info/www/bejne/aIKmhoSens2qeq8 . here you will find alternate options for Limit clause

[@John-p6p7n]

you can use top instead of limit in sql server

[@ishatawade]

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

[@radhasakhi4546]

Nice. , good video

[@ArifKhan-qo9jw]

Is this will be work in SSMS?

[@jaymahajan3871]

Good

[@CodeEra2020]

Thank you

[@shraddhadhakad1154]

Awesome 😊

[@dharmaraosalana641]

Excellent

[@palakmahajan9999]

Nice 👍

[@CodeEra2020]

Thank you so much

[@poojam271]

Thank You so much Mam

[@govindkota1026]

when we use limit function in oracle it throws error.

[@rajdeepsinghborana2409]

Informative ❤️

[@joelesthak2551]

Superb

[@CodeEra2020]

Thank you so much😊

[@khushbooparashar2556]

Good explanation

[@CodeEra2020]

Thank you so much

[@prajakta_subramanian9909]

u r brilliant

[@sandeeptripurana4496]

Good one

[@nakulanand2725]

Thanks for the info

[@CodeEra2020]

Welcome.

[@singingclub2876]

After watching this video clear the concept Thank you.../@@##

[@ankitachaudhari99]

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

[@CodeEra2020]

Thank you so much.

[@manishranjan571]

2:51,, you query is not working

[@rohitbhosale4614]

thanks please bring videos on python basic problems

[@vdharman1272]

Thanks

[@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

[@arunsinghrajpoot5363]

Please clear in limit if we have multiple rows then.

[@husainasaifee4969]

Upload more👍

[@MacTechcom]

nice explaination

[@CodeEra2020]

Keep watching

[@AshiiStories]

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

[@wasimmomin3851]

Does limit function work in MS SQL server platform?

[@SurendraYadav_]

Nope

[@ankurdixit89]

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

[@Telugufun427]

IN ORACLE THE ABOVE QUERY IS NOT WORKING > select * from(SELECT empid,empname,dept,location,sal,DENSE_RANK() OVER (ORDER BY SAL DESC) AS r FROM emp) WHERE r=3; THIS WILL WORK

[@chetansati5406]

Pls upload more cases

[@CodeEra2020]

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

[@gagandeep8710]

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

[@navyareddymanikanta4664]

Limit function not working

[@nawabigaming5301]

Limit function not work in my sql

[@CodeEra2020]

NO It is working fine in MYSQL

[@user-yy1dw5bc8y]

@@CodeEra2020 not working in sql server?

[@amolgirase2332]

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

[@harshithaharshi1175]

We can use exist and not exist

[@aparnarajlaxmi8073]

LIMIT is not working

[@bibhukalyanpatra3525]

LIMIT NOT WORK

[@VerriboinaVigneswar]

Why bro

[@marcinbadtke]

Thank you