Types of subqueries

Types of subqueries (today I couldn’t think of the term “inline view”)

1. subquery ( subselect used in where clause)

2. correlated subquery (subselect uses fields from outer query)

3. scalar subquery (subselect in select list)

4. inline views (subselect in from clause)