当使用oracle进行分页查询时使用以下方式:
SELECT *
FROM (SELECT A.*, ROWNUM RN
FROM (select t.name as name,
t.formula as formula,
t.data_from as dataFrom,
t.dept_id as deptId,
t.category as category
from k_kpi_target t
where t.del_flag = 0) A)
WHERE RN BETWEEN #{startNum} AND #{endNum}
order by rownum