The SQL subquery or inner, nested query is a query within the other. A subquery in SQL Server can nested in select, insert, delete and update.