SQL for Data Analysis
Definition and Purpose
Subquery Types
Subquery Placement
Correlated vs Non-correlated Subqueries
Single Value Returns
Use in SELECT Lists
Use in WHERE Clauses
Use in HAVING Clauses
Subqueries with IN
Subqueries with NOT IN
Subqueries with EXISTS
Subqueries with NOT EXISTS
Subqueries with ANY
Subqueries with ALL
Outer Reference Concept
Performance Considerations
Common Use Cases
Rewriting as Joins
Subqueries in FROM Clause
Table Aliases for Derived Tables
Multi-level Derived Tables
Readability
Modularity
Reusability
Recursive CTE Syntax
Base Case and Recursive Case
Hierarchical Data Processing
Graph Traversal
Previous
7. Data Transformation and Manipulation
Go to top
Next
9. Window Functions and Advanced Analytics