下面的语句复制到mapper里就报错
SELECT * FROM (SELECT f.*, ROWNUM rn FROM f_order f) WHERE rn >=2 AND rn <= 5;
解决办法
SELECT * FROM (SELECT f.*, ROWNUM rn FROM f_order f) WHERE rn >=#{pagesize} AND rn <=#{pageindex}
下面的语句复制到mapper里就报错
SELECT * FROM (SELECT f.*, ROWNUM rn FROM f_order f) WHERE rn >=2 AND rn <= 5;
SELECT * FROM (SELECT f.*, ROWNUM rn FROM f_order f) WHERE rn >=#{pagesize} AND rn <=#{pageindex}