WITH tempTable AS
(
--复杂查询语句
)
SELECT *
FROM (select ROW_NUMBER() Over( order by xxx) as rowNum,
* from tempTable) as tempTable1
where rowNum> 0 and rowNum<30
2023-12-06 12:40:16
WITH tempTable AS
(
--复杂查询语句
)
SELECT *
FROM (select ROW_NUMBER() Over( order by xxx) as rowNum,
* from tempTable) as tempTable1
where rowNum> 0 and rowNum<30