Tuesday, July 15, 2014

SubQuery in MySQL

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.