取n到m条记录的语句

1.
select top m * from tablename where id not in (select top n id from tablename)

2.
select top m * into 临时表(或表变量) from tablename order by columnname -- 将top m笔插入
set rowcount n
select * from 表变量 order by columnname desc

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


4.如果tablename里没有其他identity列，那么：
select identity(int) id0,* into #temp from tablename

取n到m条的语句为：
select * from #temp where id0 >=n and id0 <= m

如果你在执行select identity(int) id0,* into #temp from tablename这条语句的时候报错,那是因为你的DB中间的select into/bulkcopy属性没有打开要先执行：
exec sp_dboption 你的DB名字,'select into/bulkcopy',true


5.如果表里有identity属性，那么简单：
select * from tablename where identitycol between n and m 

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

------解决方案--------------------
SQL code

1. select top 10 * from a where id not in (select top 30 * from a)
2. 新闻表 news 目录表 mulu
   select top 1 a.*,b.muluname from news as a,mulu as b where a.muliid=b.id group by a.muliid order by a.time desc

------解决方案--------------------
select top 11 * from (select top 40 * from tb order by id) t order by id desc


------解决方案--------------------
探讨

引用:

select top 11 * from (select top 40 * from tb order by id) t order by id desc


这个不就查询指定范围的行吗?
如果是这样:题目应该直接及是 查录30-40条记录 吧。
后面半句话干什么用呢:根据ID不连续的排序查询?


------解决方案--------------------
学习，留下点\\\

------解决方案--------------------
所谓ID不连续,就比如;
id
---
1
3
4
6
7

那为什么题目上要明确指出id不连续呢,因为如果id是连续的,我们就可以有
select * from table where id between 30 and 40
这样的查询方式

------解决方案--------------------
select top 10 * from  a where  id not in (select top 29 * from a)