oracle分页

select * from (select *  from (select a1.*,ROW_NUMBER() over(order by mid) as rows from Menu as a1) a2 where rows<=10) b where b.rows>=6

posted on 2014-07-05 17:31  听哥哥的话  阅读(102)  评论(0编辑  收藏  举报

导航