Subquery In SQL | SQL Subquery Tutorial With Examples | SQL Tutorial For Beginners | Simplilearn

[@SimplilearnOfficial]

🔥Data Scientist Masters Program (Discount Code - YTBE15) - www.simplilearn.com/big-data-and-analytics/senior-data-scientist-masters-program-training?JksrTuEVEPk&Comments&KZbin 🔥IITK - Professional Certificate Course in Data Science (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-science?JksrTuEVEPk&Comments&KZbin 🔥Caltech Post Graduate Program in Data Science - www.simplilearn.com/post-graduate-program-data-science?JksrTuEVEPk&Comments&KZbin 🔥Brown University - Applied AI & Data Science - www.simplilearn.com/applied-ai-data-science-course?JksrTuEVEPk&Comments&KZbin

[@futuremillionairetrader6841]

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.

[@PriyaSharma-xb3ju]

Thank you for this, I was struggling with subqueries but you explained it so lucidly with examples.

[@SimplilearnOfficial]

Hello thank you for watching our video .We are glad that we could help you in your learning !

[@LuisTejadaphysiq]

This was awesome. I was struggle to understand subqueries, now i have a much better idea. Thank you

[@SimplilearnOfficial]

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.

[@javedj5338]

same here. sub queries are awesome tools, but I don't have the brains to understand. but this video helped me understand

[@KOTHAMASULAASYASREEBCD]

What is the significance of using EMPLOYEE_B in query?

[@JessicaMorrow-o2h]

Thank you for including examples!

[@sathishrao7926]

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.

[@SimplilearnOfficial]

Thank you for your review. We’ll strive to do better.

[@Irina_M1989]

Excellent tutorial! Thank you!

[@SimplilearnOfficial]

You're very welcome!

[@padmat6556]

Very nice explaination.....thank you🙏

[@SimplilearnOfficial]

Hello thank you for watching our video .We are glad that we could help you in your learning !

[@abdullahshafi4432]

Thanks for the video. Keep going.

[@SimplilearnOfficial]

Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )

[@karangusain7933]

you saved me ..Thank you

[@SimplilearnOfficial]

You're welcome!

[@petrblue]

Thanks so much.

[@SimplilearnOfficial]

You're welcome!

[@rutujapatil3967]

Nice video! It was very helpful.Thank you.

[@SimplilearnOfficial]

Hello thank you for watching our video .We are glad that we could help you in your learning !

[@mirajhossainshawon5821]

Thanks and it was very helpful

[@abdullahalshabiq130]

hello miraj

[@SimplilearnOfficial]

You're welcome!

[@1622roma]

Just perfect! Thank you!

[@SimplilearnOfficial]

You're welcome!

[@kavanajain9372]

while updating,deleting the employees list why can't we simply use where clause instead of using subquery?

[@SimplilearnOfficial]

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.

[@SimplilearnOfficial]

You can certainly use where clause. Subqueries is one of the ways to perform the same task."

[@prathameshbane7700]

I thought I was following wrong method

[@krishnajhaveri3965]

Thank uh so much sir uh explain it in very simple manner 😍

[@SimplilearnOfficial]

Most welcome 😊

[@rohanmahaldar4935]

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.

[@SimplilearnOfficial]

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!!

[@kiranguntu2692]

I didn't understand one thing...in subquery u wrote employee table as employee_b with out using alias name

[@akankshasharma9687]

employee_b is the table name. It's not using '.'

[@TomasIIILopez]

Thanks man

[@SimplilearnOfficial]

You're welcome!

[@rameshwardevkule9479]

thanks

[@SimplilearnOfficial]

You're welcome!

[@issajelili2518]

How do I download the dataset used in this video? pleased!

[@SimplilearnOfficial]

"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."

[@swatibagde-m8l]

How to find the 3rd max salary from employee

[@sureshdhandeboina7573]

Tq

[@SimplilearnOfficial]

Hope you enjoyed our video! We have a ton more videos like this on our channel. We hope you will join our community!

[@aakashprabhu7408]

Where to get database for subqueries used in the video

[@boringimmigrantcouples3046]

Hi, I could not find this course in your website?!

[@SimplilearnOfficial]

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!

[@buugedy]

You speak quite fast and its is hard to follow you at this speed.

[@SimplilearnOfficial]

Thank you for bringing this to our attention. We’re sorry you had a bad experience. We’ll strive to do better

[@mohamedidris7435]

Can you share this csv files which you used @simplelearn