提取第8行记录到第16条记录的sql语句怎么写？
如题
[解决办法]
加一個id
alter table t
add id int identity(1,1)
select * from t where id between 8 and 16
[解决办法]
好快，正解
[解决办法]
select top 9 tid
from (select top 16 tid from table) t order by t.tid desc
[解决办法]
原表结构不动的情况下 加在临时表中
select identity(int,1,1) as rowNum,* into #t from 表名
select * from #t where rowNum between 8 and 16
[解决办法]
select top 9 * from (select top 16 * from table order by id) t order by id desc
or:
select top 9 * from table where id not in (select top 7 id from table order by id) order by id
[解决办法]
方法一
select top 8 * from table where id in(select top 16 id from table order by id desc)
方法二
select identity(int,1,1) as id,* into #t from 表名
select * from #t where rowNum between 8 and 16
[解决办法]
方法一
select * from (
select top 8 * from table where id in(select top 16 id from table order by id desc)
order by id desc)
order by id
方法二
select top 8 * from table where id not in (select top 8 id from table order by id )
order by id
