Concept
Subqueries and CTEs
Queries nested inside other queries, including correlated subqueries and WITH (common table expressions), recursive ones too.
What should you learn before Subqueries and CTEs?
- SQL joinsCombining rows from two tables on a condition: inner, left, right, cross and self joins.
Connections to other concepts
- Part of
- SQL
Practise Subqueries and CTEs
- Intermediate SQL and MySQL Interview Questions2 questions on Subqueries and CTEs
- Advanced SQL and MySQL Interview Questions1 question on Subqueries and CTEs
- Second Highest SalaryCoding problem · medium