Common Table Expressions (CTE)
Recursive Common Table Expressions
Using OVER and PARTITION
Using ROW_NUMBER()
RANK() and DENSE_RANK() functions
NTILE() function
CROSS_APPLY and OUTER APPLY
User Defined Functions - Scalar
User Defined Functions - Scalar - Round Up
User Defined Functions - Inline Table Valued
User Defined Functions - Multi Statement Table Valued
Using a Collation within a SELECT list or WHERE clause
Introduction to the PIVOT keyword
More PIVOT
