62,046
社区成员
发帖
与我相关
我的任务
分享
--每页10条数据,第二页
select * from (
select top 10 * from (
select top 20 * from cjt_agent order by Id asc
) as A order by Id desc
) as B order by Id asc
select top 10 * from 表明 where 主键 not in (select top 10*(你当前的页数) * from 表明)
当前页数:
0查出来的是0-9
1查出来的是10-19
.......
以此类推
select top 1 IDentify(int,1,1) 'RowOrder',字段 from table order by RowOrder ASC
select IDentify(int,1,1) 'RowOrder',字段 from table order by RowOrder where ID in('10-19')