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