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
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