ibatis 分页

Question

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

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

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

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

Answer 1

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


rownum<=#end_row#

)

rn>#start_row#