Generate Numbers 1 to 10

Without using any table, write a recursive CTE that returns the numbers 1 to 10, one per row, in a column named n.

Table schema

No tables are required.

Sample data

(none)