SELECT Sub-Queries

Lecture

• Using SELECT Sub-Queries
• Subqueries as filters
• Subqueries as inline views
• Subqueries as additional derived columns
• Correlated Subqueries
• Where [NOT} EXISTS in Subquery
• Finding the last record from a set
• Pivoting rows into columns