SQL Window Functions
SQL Window Function
3 broad types
- Value : first_value(), last_value(), lead(), lag()
- Ranking : row_number(), rank(), dense_rank(), ntile(), percent_rank()
- Aggregate : avg(), count(), max(), min(), sum()
Value
Ranking
Aggregate
