SELECT * FROM
(
SELECT *,ROW_NUMBER() OVER(ORDER BY [fldDatdTime]) rowid FROM [ERPtblRechare]
) T
WHERE rowid BETWEEN 1000 and 2000
查询MSsql中间条数的语句
最新推荐文章于 2021-01-18 23:45:14 发布
SELECT * FROM
(
SELECT *,ROW_NUMBER() OVER(ORDER BY [fldDatdTime]) rowid FROM [ERPtblRechare]
) T
WHERE rowid BETWEEN 1000 and 2000