SQL Server vs. Oracle Generate Series or List of Numbers
转载:SQL Server vs. Oracle: Generate Series or List of Numbers
To generate a list of numbers or series in Oracle or SQL Server, we need to use recursive CTE, if we call the CTE within the CTE then it is called recursive CTE.
# SQL Server
1234567891011WITH REC_CTE(ROW_NUM) AS ( --create first record,...
more...








