Types of Subqueries
- Scaler : Only one value
- Row : One row with multiple columns
- Column Subquery : One column with multiple rows
- Table Subquery : Many columns with multiple rows
- Correlated : Is dependent on the outer query for data
- Uncorrelated : Which is not dependent on outer query for data
- LATERAL :
Subqueries in
- Where Clause
- From Clause
- Select Clause