There are three main types of SQL subqueries. These are :
* Single-row subqueries, which return one row in results
* Multi-row subqueries, which return two or more rows in results
* Correlated subqueries, which return results according to outer queries
