Lec-70: Find Nth(1st,2nd,3rd....N) Highest Salary in SQL | Imp for Competitive & Placement exam

► Structured Query Language (SQL)(Complete Playlist):

Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
►Computer Architecture (Complete Playlist):
► Theory of Computation
►Artificial Intelligence:
►Computer Networks (Complete Playlist):
►Operating System:
►Database Management System(Complete Playlist):
►Discrete Mathematics:
►Compiler Design:
►Number System:
►Cloud Computing & BIG Data:
►Software Engineering:
►Data Structure:
►Graph Theory:
►Programming in C:
►Digital Logic:

---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:
#findNthHighestSalary#SQL#DBMS

[aalirashid]

GREAT EXPLANATION SIR IN WHOLE YOUTUBE DATABASE TUTORIALS I FEEL COMFORT WITH YOUR TUTORIALS ONLY STAY BLESSED LIKE SAME FROM PAKISTAN..

[Dhirendrakumar-dkdt]

Make it very easy to understand SQL. I have watched your all series of SQL and that helps me a lot to crack my interview, thank you very much sir for sharing your information ❤️

[annoniimous]

Alternate Answer for finding nth highest salary:

SELECT Salary FROM employee
ORDER BY Salary Desc
limit 1 offset 0

Here,
limit means : how many output values you want to show on the screen ()
offset means: let assume you want to show nth (4th) highest salary . In this case you will provide offset 3 which means you
are leaving top 3 rows and you are choosing the 4th one . (( "offset means escaping the number of rows from top"))

[ayeshaameen]

Wowwww You are a genius. No one have ever taught me like this..
thank you so much for this one specially. <3

[nickbaib]

Thank you so much!
Continue the good job my friend!
Greetings from Greece!

[anitha]

Thank you so much for this video. I was struggling to understand the logic behind this and you just cleared all my doubts!!! : )

[ishangujarathi]

One of the frequently asked question in interviews and placement/internships tests, thank you so such a perfect and easy explanation!!! <3

[varshasingh]

Aapka lecture dekhe bina din achha ni jata your enthusiastic way of teaching fill Josh.

[kushagrasahu]

Your channel made SQL learning easy informative and fun🙌.

I literally binge watched sql series.

[vinitakeer]

Thank you sir jb ap bolte hai k ye meri garrenti hai that puch line is superb.... God bless you

[OmitA]

Wow sir....its a great thing to have you on youtube....very informative video....thanku so much....

[MrAmmugadu]

Thank you so much sir, before I watched your video I was totally frustrated mind, bcoz I unable to understand subqueries, but after watching your vedio really I got more analysis points on subqueries, thank you again sir

[gotamkartik]

thanks buddy, now i can understand this concept better.

[bhuppidhamii]

how does he explains every topic in a clear and comprehensible manner.😭💖

[ranjeetpatra]

The way you elucidate this complex thing is really appreciable. Hats off ❤️

[krishna]

Thank you sir, i was searching this concept from long ago, finally understood the working from your video only. Thank you for making sql easy.

[avishgoswami]

Man you nailed it...Hats off to you!!!

[kedandu]

Well explained . I highly appreciate your talent and logic.

[jovitalobo]

you explained this complex theory in awesome way. hats off to your efforts

[ayushyadav]

i think in this world there would be no teacher other than him who don't need his students to know the language he is talking in i have seen comment of ppl from all over the world appreciating him.