110,533
社区成员
发帖
与我相关
我的任务
分享
select * from Table1
select *
from (
select row_number()over(order by tempColumn)tempRowNumber,*
from (select top 10 tempColumn=0,* from Table1)t
)tt
where tempRowNumber>5
select top 20 tempColumn=0,* from Clazz
select row_number()over(order by tempColumn)tempRowNumber,*
from (修改过的查询)t
select * from (第二层)tt
where tempRowNumber>10