34,576
社区成员
发帖
与我相关
我的任务
分享
select NAME, sex, age, row_number() over (order by getdate()) jb into #a from tableNamewhere select * from #a where jb>=10 and jb<=20
select NAME, sex, age, row_number() over (order by getdate()) jb
from tableName
where jb>=10 and jb<=20
select top 10 * from(
select top 20 * from tb order by id asc)t order by id desc