取n到m条记录的语句

取n到m条记录的语句

1.
select top m * from tablename where id not in (select top n id from tablename)
set rowcount n
select * from 表变量 order by columnname desc

2.
select top n * from
(select top m * from tablename order by columnname) a
order by columnname desc


3.如果是sql server 2005 可以这样写：
select top 20 * from T order col
except
select top 2 * from T order col