A subquery is a query inside another query or it is a nested query which is embedded within the WHERE clause. Subqueries can be used with the SELECT, INSERT, UPDATE, and DELETE statements along with the operators like =, <, >, >=, <=, IN, BETWEEN etc.