--第10条到第20条记录 select top 10 * from (select top 20 * from tablename order by desc) order by id
select top 10 * from T where [某列] not in (select top 20 [某列] from T)
--第11条到第20条,共选出10条记录 select * from (select top 10 id from (select top 20 id from 表名 order by id) t1 order by id desc) t2 order by id --从第3条开始的10条记录,共选出10条记录 SELECT top 10 * FROM 表名 where id>=(select max(id) from (select top 3 id from tb order by id) t1) ORDER BY id
select top 11 * from table where id not in(select top 9 id from table order by id)
select top 10 * from (select top 20 * From 表名) a order by id desc
二楼不对吧,选出来的是从20-30的目录 select top 10 * from T where [某列] not in (select top 20 [某列] from T) 应该是 select top 10 * from T where [某列] not in (select top 10 [某列] from T) 吧
对了,应该还有order by 的语句,漏了
怎么我在SQL Server 2000里用SQL查询分析器执行,老是提示“列名 'id' 无效”。 id应该就是指记录号吧,而不是制定的字段?
--第10条到第20条记录 select top 10 * from (select top 20 * from [table] order by id) order by id desc
select top 10 * from
(select top 20 * from tablename order by desc)
order by id
select *
from (select top 10 id from (select top 20 id from 表名 order by id) t1 order by id desc) t2
order by id
--从第3条开始的10条记录,共选出10条记录
SELECT top 10 *
FROM 表名
where id>=(select max(id) from (select top 3 id from tb order by id) t1)
ORDER BY id
wangtiecheng
都是没问题的咯,不过像这种功能在SQL里面处理总是不灵活的,也不常见,一般都是放到程序里面处理,LZ可以考虑下
select top 10 * from T where [某列] not in (select top 20 [某列] from T)
应该是
select top 10 * from T where [某列] not in (select top 10 [某列] from T)
吧
id应该就是指记录号吧,而不是制定的字段?
select top 10 * from
(select top 20 * from [table] order by id)
order by id desc