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

View Notes Here - www.evernote.co...
In this video, I have explained and practically demonstrated using the Sub Query (Single Row Sub Query) in SQL statements for solving complex problems.

[@vimala7830]

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

[@QAFox]

Welcome :)

[@sudipsen3677]

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

[@abhiram6578]

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;

[@gantaavinash169]

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

[@QAFox]

Sure Avinash :)

[@informationadda758]

ossum explanation dude

[@QAFox]

Thank you :)

[@mathiassintal2237]

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!

[@purushotamsharma3710]

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

[@campeiangomes4298]

great job

[@QAFox]

Thank you :)

[@anjalinayak1001]

Thank you sir

[@rahulk3209]

Sir I think you forgot to upload about normalization topic

[@QAFox]

Those topics will be covered later. I am working on other things now.

[@filmflasheshq]

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

[@filmflasheshq]

SELECT price AS 2nd_max_price FROM products ORDER BY price DESC LIMIT 1 , 1 ;

[@QAFox]

Yeah another way to get the results.

[@dushyant.june6]

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

[@QAFox]

Go to that particular topic in W3SCHOOLS website and try.

[@rayberlin8005]

Sir, notes missing here.

[@QAFox]

Thanks for letting me know. I have updated the description and provided the notes now.

[@farihaaskar6053]

can you be my sql tutor, ill pay u

[@QAFox]

Sorry, not getting time.