Subqueries vs JOINs comparison in MySQL - Quick Revision & Key Differences

Recall & Review

beginner

What is a subquery in SQL?

A subquery is a query nested inside another query. It runs first and its result is used by the outer query.

beginner

What does a JOIN do in SQL?

A JOIN combines rows from two or more tables based on a related column between them.

intermediate

When might you prefer a JOIN over a subquery?

You might prefer a JOIN when you want to combine data from multiple tables in one result set efficiently.

intermediate

Can subqueries be used in the SELECT, FROM, or WHERE clauses?

Yes, subqueries can appear in SELECT, FROM, or WHERE clauses depending on what you want to achieve.

intermediate

Which is generally faster: JOINs or subqueries?

JOINs are often faster because they let the database optimize how tables are combined, but it depends on the query and indexes.

What does a JOIN do in SQL?

A Combines rows from two or more tables based on a related column

B Runs a query inside another query

C Deletes rows from a table

D Creates a new table

A JOIN combines rows from tables based on matching columns.

Where can a subquery NOT be used?

A In the WHERE clause

B In the FROM clause

C In the CREATE TABLE statement

D In the SELECT clause

Subqueries are not used in CREATE TABLE statements.

Which is usually more efficient for combining tables?

A Subqueries

B JOINs

C Both are always equal

D Neither can combine tables

JOINs are usually more efficient for combining tables.

A subquery is:

A A query inside another query

B A type of JOIN

C A database index

D A table alias

A subquery is a query nested inside another query.

Which SQL clause can contain a subquery?

A LIMIT

B GROUP BY

C ORDER BY

D WHERE

Subqueries can be used in the WHERE clause to filter results.

Explain the main differences between subqueries and JOINs in SQL.

Think about how data is combined and when each is useful.

Describe a situation where using a JOIN is better than a subquery.

Consider when you want to see related data side by side.