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}
07-04
2087
04-08
1554