SQL - Part 60 - Sub Query (Single Row Sub Query explained by solving different problems)

In this video, I have explained and practically demonstrated using the Sub Query (Single Row Sub Query) in SQL statements for solving complex problems.

[sudipsen]

Bro use this sub query to find nth max Price * from Products p1 where 1=(select count(distinct Price) from Products p2 where p2.Price>p1.Price );

[Ram-li]

can we write the query like this for
finding the third maximum price of the products.

select price from the products order by price desc llmit 2, 1;

[vimalvrk]

Clear explanation sir thanks a lot ☺️☺️☺️

[mathiassintal]

select price from products order by price desc limit 1, 1
would also result with the second highest price, right?

Thank you very much for your tutorials!

[gantaavinash]

Thanks a lot sir for your tutorials, if possible please do on nodejs

[purushotamsharma]

sir, i really enjoyed your video.
a request to you sir, can you please upload a single note for or video

[filmflasheshq]

Sir we can also use LIMIT to retrieve 2nd, 3rd, etc max data

[dushyant.june]

Sir what source are you using for these practice questions?
Kindly provide me with the link please!!

[rahulk]

Sir
I think you forgot to upload about normalization topic