Where to Use Sub-Queries
A sub-query can stand in for a value, a list or a table. Use it in WHERE with =, IN, NOT IN or EXISTS, as a column in the SELECT, or as a table in the FROM.
Updated
- Category
- SQL
- Level
- Journeyman
- Tags
- EXISTS Predicate, IN Predicate, Scalar Subquery, sql, Table Subquery, t-sql