ＳＱＬ

■■ページング
■rownum コスト低

select * from
(select rownum no,a.* from
(select DIGI_TRADE_ID,TRADE_DATE from VP_SYS.MUN_HIST_PARTNER_TRADE order by TRADE_DATE desc) a
)
where no between 5 and 10

■row_number() コスト中

select * from
(select
DIGI_TRADE_ID
,TRADE_DATE
,ROW_NUMBER() OVER (ORDER BY TRADE_DATE desc) NUM
from VP_SYS.MUN_HIST_PARTNER_TRADE
order by TRADE_DATE desc
)
where NUM between 5 and 10

■trunc
trunc(up.CREATE_DATE,'MM')=trunc(TO_DATE('20130501', 'YYYYMMDD'),'MM')
■