top of page
  • Writer's picturekyle Hailey

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)

0 views0 comments
bottom of page