SELECT P.*, ROWNUM AS rowno FROM
(SELECT * FROM "equipment_info","equipment_status","user","parking_lot"
WHERE "equipment_info"."parking_id"="parking_lot"."id"
and "equipment_info"."status"="equipment_status"."id"
and "equipment_info"."principal_id"="user"."id") P
WHERE ROWNUM < #{nextOffset,jdbcType=INTEGER}) T
WHERE T.rowno >= #{pageOffset,jdbcType=INTEGER}
联表查询所有记录和equipment_info的记录条数
得到缺失右括号的问题
检查语法什么都没有问题
猜测可能是因为这种联表查询查记录个数有问题
改为左联表
SELECT P.*, ROWNUM AS rowno FROM
(SELECT * FROM "equipment_info" left join "parking_lot" on "equipment_info"."parking_id"="parking_lot"."id"
left join "equipment_status" on "equipment_info"."status"="equipment_status"."id"
left join "user" on "equipment_info"."principal_id"="user"."id") P
WHERE ROWNUM < #{nextOffset,jdbcType=INTEGER}) T
WHERE T.rowno >= #{pageOffset,jdbcType=INTEGER}
解决了问题