🔥Data Scientist Masters Program (Discount Code - YTBE15) - www.simplilearn.com/big-data-and-analytics/senior-data-scientist-masters-program-training?JksrTuEVEPk&Comments&TH-cam 🔥IITK - Professional Certificate Course in Data Science (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-science?JksrTuEVEPk&Comments&TH-cam 🔥Caltech Post Graduate Program in Data Science - www.simplilearn.com/post-graduate-program-data-science?JksrTuEVEPk&Comments&TH-cam 🔥Brown University - Applied AI & Data Science - www.simplilearn.com/applied-ai-data-science-course?JksrTuEVEPk&Comments&TH-cam
in this institute everybody highly qualified i guess not a single trainer left u with question mere jaisa non it wala understanding the conceps its means trully this people are gem.
Hmm.. Not sure if these are the most relevant examples for subqueries since 'where' clause can be used directly without subqueries in all these examples.. Use of subqueries to accomplish these tasks is certainly going to confuse beginners.
Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.
Well You are correct that there are more than 4 types of sub-queries, and sub-queries with a FROM clause are one of the types. The four commonly used subqueries are scalar subqueries which returns a single value , multiple rows and column subqueries which return one or more values and correlated subqueries which refers to a column from the outer query and is evaluated once for each row processed by the outer query. These sub-queries are often used with from or having clauses to create more complex queries and are often necessary to achieve specific data manipulations. I hope you've understood Thanks!!
Thank you for letting us know know about this. Your feedback helps us get better. We are looking into this issue and hope to resolve it promptly and accurately.
"Hi , you can find many datasets on google. There are many websites which provide free access to datasets to perform SQL Analysis and one such popular platform we can recommed is K Kaggle: A platform that hosts a wide range of datasets, including those related to SQL. You can search for datasets on Kaggle and download them after creating an account."
Hi, Simplilearn provides online training across the world. We would be happy to help you regarding this. Please visit us at www.simplilearn.com and drop us a query and we will get back to you! Thanks!
![CAMPปลิ้น | EP.83[1/2] เปิดแคมป์หลอนต้อนรับ 2 ตัวพ่อแห่งวงการผี!](http://i.ytimg.com/vi/2uPuHYHgwiI/mqdefault.jpg)
![[LIVE] : ONE ลุมพินี 83 วันนี้!! คู่เอก "พันฤทธิ์ vs ซุปเปอร์บอล วันของโอม MBK"](http://i.ytimg.com/vi/1b4pkKHa_Fk/mqdefault.jpg)
🔥Data Scientist Masters Program (Discount Code - YTBE15) - www.simplilearn.com/big-data-and-analytics/senior-data-scientist-masters-program-training?JksrTuEVEPk&Comments&TH-cam
🔥IITK - Professional Certificate Course in Data Science (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-science?JksrTuEVEPk&Comments&TH-cam
🔥Caltech Post Graduate Program in Data Science - www.simplilearn.com/post-graduate-program-data-science?JksrTuEVEPk&Comments&TH-cam
🔥Brown University - Applied AI & Data Science - www.simplilearn.com/applied-ai-data-science-course?JksrTuEVEPk&Comments&TH-cam
Thank you for this, I was struggling with subqueries but you explained it so lucidly with examples.
Hello thank you for watching our video .We are glad that we could help you in your learning !
in this institute everybody highly qualified i guess not a single trainer left u with question mere jaisa non it wala understanding the conceps its means trully this people are gem.
Thank you for including examples!
What is the significance of using EMPLOYEE_B in query?
Hmm.. Not sure if these are the most relevant examples for subqueries since 'where' clause can be used directly without subqueries in all these examples.. Use of subqueries to accomplish these tasks is certainly going to confuse beginners.
Thank you for your review. We’ll strive to do better.
This was awesome. I was struggle to understand subqueries, now i have a much better idea. Thank you
Thank you for the appreciation. You can check our videos related to various technologies and subscribe to our channel to stay updated with all the trending technologies.
same here. sub queries are awesome tools, but I don't have the brains to understand. but this video helped me understand
Thanks so much.
You're welcome!
Excellent tutorial! Thank you!
You're very welcome!
What do you mean when you say there are 4 types of sub-queries ? Like I have seen sub-queries with from clause as well.
Well You are correct that there are more than 4 types of sub-queries, and sub-queries with a FROM clause are one of the types. The four commonly used subqueries are scalar subqueries which returns a single value , multiple rows and column subqueries which return one or more values and correlated subqueries which refers to a column from the outer query and is evaluated once for each row processed by the outer query. These sub-queries are often used with from or having clauses to create more complex queries and are often necessary to achieve specific data manipulations. I hope you've understood Thanks!!
Very nice explaination.....thank you🙏
Hello thank you for watching our video .We are glad that we could help you in your learning !
while updating,deleting the employees list why can't we simply use where clause instead of using subquery?
Thank you for letting us know know about this. Your feedback helps us get better. We are looking into this issue and hope to resolve it promptly and accurately.
You can certainly use where clause. Subqueries is one of the ways to perform the same task."
I thought I was following wrong method
you saved me ..Thank you
You're welcome!
Thanks and it was very helpful
hello miraj
You're welcome!
Thanks for the video. Keep going.
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
Nice video! It was very helpful.Thank you.
Hello thank you for watching our video .We are glad that we could help you in your learning !
Just perfect! Thank you!
You're welcome!
thanks
You're welcome!
Thank uh so much sir uh explain it in very simple manner 😍
Most welcome 😊
How do I download the dataset used in this video? pleased!
"Hi , you can find many datasets on google. There are many websites which provide free access to datasets to perform SQL Analysis and one such popular platform we can recommed is K
Kaggle: A platform that hosts a wide range of datasets, including those related to SQL. You can search for datasets on Kaggle and download them after creating an account."
How to find the 3rd max salary from employee
I didn't understand one thing...in subquery u wrote employee table as employee_b with out using alias name
employee_b is the table name. It's not using '.'
Thanks man
You're welcome!
Tq
Hope you enjoyed our video! We have a ton more videos like this on our channel. We hope you will join our community!
Hi, I could not find this course in your website?!
Hi, Simplilearn provides online training across the world. We would be happy to help you regarding this. Please visit us at www.simplilearn.com and drop us a query and we will get back to you! Thanks!
Where to get database for subqueries used in the video
You speak quite fast and its is hard to follow you at this speed.
Thank you for bringing this to our attention. We’re sorry you had a bad experience. We’ll strive to do better
Can you share this csv files which you used @simplelearn