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