In SQL Server, a subquery is a query within a query. You can create subqueries within your SQL statements. These sub queries can reside in the WHERE clause, the FROM clause, or the SELECT clause. Example:- SELECT p.product_id, p.product_name FROM products p WHERE p.product_id IN(SELECT inv.product_idFROM inventory invWHERE inv.quantity > 10);