sql 查询分页_排序

select ttt.* from (
select tt.*,rownum as r
  from (select t.articleid, t.arttitle, t.arttime
          from article t
         where t.fieldid = 1563 order by t.arttime desc
) tt
 )ttt where ttt.r between 0 and 7