ibatis 分页

请问以下面的方式实行分页具体应该怎么写:

List list=getSqlMapClientTemplate().queryForList("select", null, start, limit);

错误的配置文件（应该如何配置编写）oracle数据库

select * from
(select m.*,rownum r from aa m where rownum<#limit#)
where r>#start#

select * from (
select * from goods where 1=1


rownum<=#end_row#

)

rn>#start_row#

select *
from (select m.*,row_number() over(order by id desc) as rNo
from aa m)
where rNo >= #start#
and rNo < #start#+#limit#

取值范围是
rownum>start_row and rownum<=limit