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
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?
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.❤️
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
Very nice. Thank 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?
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.❤️
Superb. Thank you.
12:36 should there be having?? in place of where.
Nice explanation 👏
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
Very good and simple explanation thanks 🙌
Very well explained ma'am
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
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
Best video for sub query