SQL for Data Analysis
UNION Operator
UNION ALL Operator
INTERSECT Operator
EXCEPT Operator
Set Operator Rules
Column Compatibility
Set Operator Precedence
Manual Pivoting with CASE
PIVOT Operator
UNPIVOT Operator
Manual Unpivoting
Hierarchical Data Queries
Tree Traversal
Graph Analysis
Query Rewriting
Predicate Pushdown
Join Elimination
Subquery Optimization
Previous
9. Window Functions and Advanced Analytics
Go to top
Next
11. Views and Temporary Objects