CTE

Recursive CTE

Common table expressions (CTE)

The number-sequence generation

Typical problems

Other examples of using window functions

Window functions

Aggregate function to aggregate function

Getting summarizing values

Common table expressions (CTE)

New sql features