The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Anybody can ask a question
Anybody can answer
The best answers are voted up and moderated by our team

Use of SQL subquery and Join

Use of SQL subquery and Join


SQL Subqueries Video 1
Instead of using SQL subquery I used JOIN query which gave the same output. ALso the JOIN syntax was much simpler to use. Then why Subquery is required?

1 Answer

365 Team

Hi Neelanjan!
Thanks for reaching out!
Although it is true sometimes one can obtain the same ouptut by using different SQL tools, there are many situations in which a join won’t be able to deliver the same result as a subquery, therefore you need to be well prepared on how to use a subquery in MySQL. That’s why we teach it and it is important to focus on the structure of using subqueries (as you can see, there are several types of subqueries and they are not in any way completely identical in terms of purpose for use!).
Hope this helps.

Sure, thanks martin

8 months

You are welcome!

8 months
Online Data Science Training
SAVE 60%