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)

3 views0 comments

Recent Posts

See All


bottom of page