select *
from (select row_.*, rownum rownum_
from (
select *
from AL_RLSB
where
<![CDATA[ TO_CHAR(DISCERNTIME, 'YYYY-MM-DD') < TO_CHAR(SYSDATE, 'YYYY-MM-DD') ]]>
ORDER BY DISCERNTIME desc
) row_
where rownum <= #{end})
where rownum_ > #{start}
Oracle时间判断何分页
最新推荐文章于 2023-11-20 09:14:12 发布