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.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Use of SQL subquery and Join

Back to all questions

Use of SQL subquery and Join

6 months ago
Vote Up Vote Down
0
Votes
1
Answer

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 6 months ago
Vote Up Vote Down
1
Vote

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.
Best,
Martin

Sure, thanks martin

– 6 months

You are welcome!

– 6 months
You must to answer this question.

Not the answer you are looking for? Browse other questions tagged #, #, #.

×
Ready to Learn
Data Science?
50% OFF