36 Subquery in SQL | Complete Subqueries Tutorial in ONE Video | Types of Subqueries | Advance SQL

[@k.chriscaldwell4141]

Superb. Thank you.

[@GaurishankarPatle-w1f]

Please make a video on cte,view,local &global table,stocked procedures , you explaination verry good. It will help to clear all doubts. Thanks for sharing your knowledge with us .thanks

[@deyscube577]

I was watching a lot of videos on the same topic..all doubts cleared here only. Reason why best: with example of each subqueries like (=,=/in,not in,any/examples on correlated) This points helped me to clear which bigger channels could not do. Fond of you.❤️

[@PraveenKumar-ur4jl]

Very nice. Thank you

[@osoriomatucurane9511]

Awesome tutorial on sql subqueries. Concise, crystal clear. The scalar and multiple rows subqueries are kind of chaining operation in R and Python. The output from previous operation, as an intermediate step, is called and used in the next operation. Correct?

[@lavanyakoppuravuri5470]

Nice explanation 👏

[@vitthalsabale7108]

Hello Saloni, Thank you for sharing your SQL session, it's very help full for beginner's. In this session you have mentioned ORDER BY command can't be used in a Subquery, So please check below query and suggest me know, Is this Subquery or not ? because we are using ORDER BY clause under this query. SELECT TOP 1 SALARY FROM (SELECT DISTINCT TOP 3 SALARY FROM EMPLOYEE ORDER BY SALARY DESC) EMPLOYEE ORDER BY SALARY ASC; I hope you will reply on this comment to clear my doubts

[@sajalshrivastava2202]

Very well explained ma'am

[@Businessbol]

Very good and simple explanation thanks 🙌

[@anupamaindapure6941]

hello mam , where did you learn this all content was so informative. can this sql can enough for data analyst or data engineer role?can you suggest please??

[@VIBHAV-SOMVANSI]

These sql contents are not enough for data engineer. Learn Pl/sql as well.

[@satyamkumaarr]

12:36 should there be having?? in place of where.

[@Rohith_08]

Super ❤❤

[@jaymahajan3871]

Good 👌😊😊👍

[@kritikarya3204]

Hey, you are really doing a noval job sharing your experties but i've a suggestion about your "guys count". Lol

[@tracyojila]

Please how can i get this data you are working with please☺☺☺☺

[@talknow2859]

I built mine using the Create database command in her earlier videos in this series.

[@developerritesh]

❤❤❤

[@sarthakarora5469]

"so guys"

[@shitaldesai9139]

Hello madam

[@yon1623]

does learning subqueries going to get me a girlfriend

[@SouhridyoBose]

Blud asking the real *queries* here

[@_badboikiller_]

Best video for sub query