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;
转载于:https://blog.51cto.com/liweibird/497355
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;
转载于:https://blog.51cto.com/liweibird/497355