oracle 分页

2023-11-01 77 阅读1分钟


select *
from (SELECT t.*, rownum rn
      FROM wssyjx.FA_YQSBGLJBXXMX t
      WHERE rownum &lt; ${query.current * query.size+1}
     ) f
where rn > ${(query.current - 1)*query.size}