SQL简单分页方

--返回数据
select * from dbo.MOCTC

--考虑到低版本SQL2000，使用identity(int,1,1),增加ID自增

select  identity(int,1,1) as id,* into _temp from dbo.MOCTC

--返回临时表_temp数据

select * from _temp

--我佛慈悲，返回第页数据，第页笔数

select top 10 * from _temp where id not in (select top (10*(1-1)) id from _temp order by id) order by id

--我佛慈悲，返回第页数据，第页笔数

select top 10 * from _temp where id not in (select top (10*(2-1)) id from _temp order by id) order by id

--我佛慈悲，返回第页数据，第页笔数

select top 10 * from _temp where id not in (select top (10*(3-1)) id from _temp order by id) order by id

--第一

select top 10 * from (select row_number() over (order by TC002) as row,* from dbo.MOCTC) a where row>(10*(1-1))

--第二

select top 10 * from (select row_number() over (order by TC002) as row,* from dbo.MOCTC) a where row>(10*(2-1))

--第三

select top 10 * from (select row_number() over (order by TC002) as row,* from dbo.MOCTC) a where row>(10*(3-1))

select top 10 * from _temp where id> (select isnull(max(id),0) from (select top (10*(1-1)) id from _temp order by id)a) order by id

select top 10 * from _temp where id> (select isnull(max(id),0) from (select top (10*(2-1)) id from _temp order by id)a) order by id

select top 10 * from _temp where id> (select isnull(max(id),0) from (select top (10*(3-1)) id from _temp order by id)a) order by id

📱 扫码关注公众号

扫描二维码关注我们，获取更多精彩内容
实时更新 · 干货满满