查录30-40条记录，根据ID不连续的排序查询 有一个新闻表和目录表，查询每个目录下最新的一条新闻,该如何解决

取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 nselect * from 表变量 order by columnname desc3.select top n * from (select top m * from tablename order by columnname) aorder by columnname desc4.如果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',true5.如果表里有identity属性，那么简单：select * from tablename where identitycol between n and m 6.如果是sql server 2005 可以这样写： select top 20 * from T order by colexceptselect 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)