Introduction to Subqueries

Learn how to nest queries inside other queries.

We'll cover the following

A subquery is a query that is part of another large query. T-SQL queries can be complex and consist of multiple subqueries.

Why subqueries?

Let’s consider these tables for Schools and Students with the following structure.

Get hands-on with 1200+ tech skills courses.