Question

我想从第三条新闻开始显示！显示5条新闻！这个sql语句怎么写呀？

Answer 1

select top 5 * from news where id not in (select top 2 id from news where mokuai='荣川新闻') and mokuai='荣川新闻'

Answer 2

select top 5 * from new where id not in(select top 3 id from new order by id)