提取表中头10条,头11-20,21-30条,31-40条数据按id降序

[zhirui]

如标题.谢谢!

[jaway]

到这搜索个翻页存储过程就是了

[dawugui]

select top 10 * from table order by id desc

select top 20 * from table where id not in (select top 10 * from table) order by id desc

select top 30 * from table where id not in (select top 20 * from table) order by id desc

select top 40 * from table where id not in (select top 30 * from table) order by id desc

[tippointGmail]

select top 10 * from table order by id desc

select top 20 * from table where id not in (select top 10 * from table order by id desc) order by id desc

select top 30 * from table where id not in (select top 20 * from table order by id desc) order by id desc

select top 40 * from table where id not in (select top 30 * from table order by id desc) order by id desc

[longli67]

象上面的写法数量大的时候效率怎么样呢？