使用WITH AS 的ROW_NUMBER分页时间:2023-03-09 05:40:17 WITH tempTable AS( --复杂查询语句) SELECT * FROM (select ROW_NUMBER() Over( order by xxx) as rowNum, * from tempTable) as tempTable1where rowNum> 0 and rowNum<30