DB2 分页

1、  示例分页

正确分页

 select issue_name, row_num from

 (

select issue_name, rownumber() over(order by issue_name desc) as row_num from

(

           select issue_name from tab_issue

)

)

 where row_num between 2 and 6

2、  程序应用分页编写模板

正确的分页

  select TRADE_ORDER ,TRADE_TIME ,TRADE_FEE ,IN_MONEY ,TRADE_DESC from

 (

select TRADE_ORDER ,TRADE_TIME ,TRADE_FEE ,IN_MONEY ,TRADE_DESC , rownumber() over(order by TRADE_TIME desc) as row_num from

(

           select * from TAB_QD_TRADE_LIST  where USER_ID =100010678 and TRADE_TIME between to_date('2007-02-02' ,'YYYY-MM-DD') and to_date('2011-02-02'  ,'YYYY-MM-DD')

)

)

3、orical 中的字符转日期to_date(‘20007-02-02’,’YYYY-MM-DD’) db2中同上。