CTE
The number-sequence generation
Typical problems
Using recursive CTE
Common table expressions (CTE)
Other examples of using window functions
About window functions
Aggregate function to aggregate function
Getting summarizing values
Common table expressions (CTE)
New sql features