SQL查询前5条记录但是不包括第一条记录 怎么处理？
SQL查询前5条记录但是不包括第一条记录 怎么处理？
select top 5 newsid,newstitle,NewsContent,PicUrl,newstime from njsqnews where categoryid=199 and v2=1 and newsid not in (select top 1 newsid from njsqnews where categoryid=199 and v2=1) order by ordertime desc
我写的这个不起作用啊！
求大师指导
[解决办法]
select top 5 newsid,newstitle,NewsContent,PicUrl,newstime from njsqnews where categoryid=199 and v2=1 and newsid not in (select top 1 newsid from njsqnews where categoryid=199 and v2=1 order by ordertime desc) order by ordertime desc
[解决办法]
select top 5 * from [dbo].[ArcType]
where id not in(select top 1 id from ArcType)
注意 外面的SQL和里面的SQL where 和order by 都要一样
