楚落凡尘

oracle分页

select *
from (select i.*, row_number() over(order by ID asc) rank FROM t_purc_file i)
where rank >= 2
AND rank <= 4;

posted on 2018-12-21 20:12  楚落凡尘  阅读(97)  评论(0编辑  收藏  举报

导航