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
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.❤️
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?
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
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??
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
12:36 should there be having?? in place of where.
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.❤️
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?
Very nice. Thank you
Superb. Thank you.
Nice explanation 👏
Very good and simple explanation thanks 🙌
Very well explained ma'am
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
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??
These sql contents are not enough for data engineer. Learn Pl/sql as well.
Good 👌😊😊👍
Super ❤❤
Hey, you are really doing a noval job sharing your experties but i've a suggestion about your "guys count". Lol
❤❤❤
Best video for sub query
Please how can i get this data you are working with please☺☺☺☺
I built mine using the Create database command in her earlier videos in this series.
"so guys"
Hello madam
does learning subqueries going to get me a girlfriend
Blud asking the real *queries* here