sql server中如何取从第二条开始往后的N条记录?

[netstu]

在mysql中是select * from tables limit 2,n;

SQL SERVER没玩过.

[KimSoft]

呵呵，在oracle中是select * from(select * from table) where rownum > 1 and rownum < n+1

sqlserver关注一下。

[奋斗男人]

select * from table where id<>(select top 1 * form table)

[netstu]

sqlpic="select top 3 * from news_purpose where int(maoa)=1 and id<>(select top 1 * from news_purpose where int(maoa)=1) order by newsdate desc,id desc"


我这样做会出现http500错误呀

[chinastorm]

sqlpic="select top 3 * from news_purpose where int(maoa)=1 and id<>(select top 1 [id] from news_purpose where int(maoa)=1) order by newsdate desc,id desc"
这样行不？

[netstu]

还是不行

[netstu]

现在出现的内容还是select top 3 * from news_purpose where int(maoa)=1 order by newsdate desc,id desc的结果

[月小升java-er点com]

select top n * from tables where (id not in (selet top 1 id from tables order by id )) order by id

[月小升java-er点com]

写错了一个select
正确的如下
select top n * from tables where (id not in (select top 1 id from tables order by id )) order by id

[netstu]

我再试一下