问一个sql的问题,我不会!

[打转的风铃]

我想查前六条吧,就写select top 6 .

那我要是查7---12条的记录,怎么写啊?
13---18啥的!谢谢!!!

[小昭]

7-12，就是5条，你可以select top 5 * from table where id not in (select top 7 id from table)

[diegoyu]

select top 6* from Employee where ID not in(select top 6 ID from Employee)

[打转的风铃]

1

[zishanyan]

如果只是Sql语句的话，我就做下搬运工发个链接上来

http://bbs.tech.ccidnet.com/read.php?tid=111362

[fengjian_428]

select top 12* from tb where id not in(select top 7 id from tb )

[HooverHuang]

你换个思路想象撒。。。

你要查 7-12条的，
你排序下，然后将 前6条 排除，再去前5条不就可以了么

查出前 6条的ID,然后条件里面写 ，id不等于这6 个ID的前 5五条数据就是你想要的

[HooverHuang]

select top 12* from cn_H_ContactUs where id not in(select top 7 id from cn_H_ContactUs )

[ck11926375]

http://blog.csdn.net/anchor_jsyc/archive/2007/09/27/1803751.aspx

[cngothic]

你这样要做什么分页？

select top 6 max(id), * from table
记录num = max(id)

select top 6 max(id), * from table where id > num
记录num = max(id)

select top 6 max(id), * from table where id > num
记录num = max(id)

[kan1232008]

with t_rowtable as(select row_number() over(order by z.ID) as row_number,z.ID from table as z) select * from t_rowtable where row_number>='" + start + "' and row_number < ='" + end + "' order by ID

只能用在SQL2005

[Kobayashi]

select top 6 * from cn_H_ContactUs where id not in(select top 7 id from cn_H_ContactUs  )

应该这样做。

[ouc_ajax]

[Quote=引用 9 楼 ulihss 的回复:]
SQL codeselecttop6*from cn_H_ContactUswhere idnotin(selecttop7 idfrom cn_H_ContactUs )
应该这样做。
[/Quote]

up! 如果是Oracle的可以看看Row_num关键字。

[xiongshao1943]

[Quote=引用 3 楼 fengjian_428 的回复:]
select top 12* from tb where id not in(select top 7 id from tb )
[/Quote]
正解了,就是换一种思路

[打转的风铃]

up^_^

[qxq421367660]

select * from tb_name where 12>id or id>7
这种方法也行

[qxq421367660]

写错了应该是：select * from tb_name where id>7 and id<12

[奔腾286]

select top 12 * from table where not in (select top 7 * from table)

[kele1006]

select * from (select row_number() over (order by Id) as rowId ,* from tb) t
where t.RowId between 7 and 12

[heronexus]

给你思路：想TOP 12一下，倒序输出，在TOP 6一下输出，得到的记录就是7~12条的记录了！

[打转的风铃]

没有ID的话,是不是只有用not in!!!