Lec-60: SQL Queries and Subqueries (part-2) | 2nd Highest Salary | Nested Queries | DBMS

0:00 - Introduction
0:56 - Question 1
7:33 - Question 2

►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:

[karnavpanchal]

I found no teacher explainaing like you, not even canadian teachers! i am studying in canada and due to your videos my concepts are so clear that i can confidently answer the questions. Thanks a lot. JAI HIND!!!

[ShivAdiShakti]

Best Teacher! Selfless Work for all the Students. Its great to have teachers like you. :)

[AmandeepSingh-tcfz]

Wonderful. Very few teachers explain the logic.u r the one of them

[sulaimant]

Watched the entire playList couple of days before my Interview, Guess what ?,
The first interview question was "Write a query to find the Second Highest Salary? "

Truly Great Content and Teaching Style,
Thank you for the hard work.

[rahulmishra]

I am working as SQL developer/Analyst . Your teaching std. is really amazing sir.

[sumeetkaur]

it is very helpful to understand SQL, Excellent way of explaining the things

[shikharupadhyay]

I am so impressed by your teaching, that I have recommended your channel to all my peers and requested them to follow.
May God bless you!

[dibyendubiswas]

I see all video in dbms and now concept is very clearly.
Thank you very much sir, for those video.
Love you lot...❤❤❤❤❤

[debinaik]

Boss, you are God gifted. Love to watch all your lecture. May God bless you forever.

[comraza]

Sir aap legend aapki dbms or SqL ki video one month se dekh rha har lecture ki video fully samjh mai aarha h....sir love from

[hi.]

i usually dont comment . but your hardwork, determination and quality content forced me to comment .
after all i thank you for making this whole playlist.

[suprakashbanerjee]

thank you so much, sir. The way you explain things is so good. Thanks for being our DBMS Savior.

[MYHPYWORLD]

Best Teacher in You Tube for SQL as you have not just written these queries, you have explained them properly.

[appyapoorv]

Great explanations! just another approach, i dont know its feasible or not.
select * from emp order by salary desc limit 1 offset 1;

[sajansekhu]

aapki hr vedio main sir bahut kuch seekhne ko milta hai jo hmne master's main nhi thnkk u so much....may u achieve u r all dreams....i prey to god sir....thnkk u so much ji..🙏🙏🙏

[nirajanandansamal]

Your work is God level work.hats off sir

[AnishaSharma-fw]

sir u r the best teacher . aapne engineering bhot easy krdi hai

[ankush_in_sync]

You deserve more followers and Subscribers. He explains the best. Thank you.

[bhushanwagh]

Bhai.. Kya jabardast explanation hain... Awesome

[happycoding]

you are the best teacher and thanks alott sir for teaching in such a great want more videos from you..