select * from tab where id between m and n order by id desc
让他们重新设计了一下table,加了一个索引idselect top M * from table where id> (select max(id) from (select top N id from table order by id) a) order by idselect top M * from table where id not in (select top N id from table) order by id 如果M100 N200 查出的数据是从201开始的 杯具了,用的是sql2005
原来select top M * from table where id> (select max(id) from (select top N id from table order by id) a) order by idN应该改为M select top M * from table where id> (select max(id) from (select top M id from table order by id) a) order by id
from table
where id> (select max(id) from (select top N id from table order by id) a)
order by idselect top M *
from table
where id not in (select top N id from table)
order by id
如果M100 N200 查出的数据是从201开始的
杯具了,用的是sql2005
from table
where id> (select max(id) from (select top N id from table order by id) a)
order by idN应该改为M
select top M *
from table
where id> (select max(id) from (select top M id from table order by id) a)
order by id