Types of subqueries (today I couldn't think of the term "inline view")
- subquery ( subselect used in where clause)
- correlated subquery (subselect uses fields from outer query)
- scalar subquery (subselect in select list)
- inline views (subselect in from clause)
No comments:
Post a Comment