select top 7 * from (select top 15 * from tablename) order by id desc
select top 7 * from tablename where id in (select top 15 * from tablename) order by id desc
select top 7 * from tablename where id not in (select top 8 * from tablename order by id desc) order by id desc
都读取出来,然后把第9-15条重datatable中读出来显示就可以了。
select top 7 * from tablename where id in (select top 15 * from tablename) order by id desc 这句就有问题,id in (select top 15 * from tablename) 是不行的你只能id in (select id)
而且如果时oracle,top 7 也不能用你只能用select * dd from where rownum=15 order by id desc
select top 7 * from tablename where id>(select max(id) from (select top 8 * from tablename order by id asc) as a) order by id asc 搞定!也可以调整为desc的!想取哪段数据随便你!7和8可以任你调整!^_^
这句就有问题,id in (select top 15 * from tablename) 是不行的你只能id in (select id)