Data有40多万行数据,要求分页导出Data.

SQL 2005 数据库:

WITH table2 AS
(
SELECT *,
ROW_NUMBER() OVER (order by wc_date)as RowNumber
FROM table1
)
SELECT *
FROM table2
WHERE RowNumber between 1 and 65534;