hibernate 分页sql

SELECT *
FROM
  (SELECT row_.*,
     rownum rownum_
   FROM
    (SELECT this_.id AS
     id31_0_,
       this_.version AS
     version31_0_,
       this_.currency_code AS
     currency3_31_0_,
       this_.decimal_in_word AS
     decimal4_31_0_,
       this_.decimal_place AS
     decimal5_31_0_,
       this_.description AS
     descript6_31_0_,
       this_.effective_date AS
     effective7_31_0_,
       this_.termination_date AS
     terminat8_31_0_,
       this_.unit_in_word AS
     unit9_31_0_,
       this_.crt_ts AS
     crt10_31_0_,
       this_.crt_usr AS
     crt11_31_0_,
       this_.lst_action AS
     lst12_31_0_,
       this_.lst_upd_ts AS
     lst13_31_0_,
       this_.lst_upd_usr AS
     lst14_31_0_,
       this_.used_flag AS
     used15_31_0_,
       this_.archived_flag AS
     archived16_31_0_,
       this_.active_flag AS
     active17_31_0_,
       this_.common_udf_data_id AS
     common18_31_0_
     FROM cf_currency this_
     WHERE this_.active_flag = 'Y'
     ORDER BY this_.currency_code ASC)
  row_
   WHERE rownum <= 72)
WHERE rownum_ > 40;