1??rest api run correctly
SELECT b.outid, SUM(b.opfare) AS sums
FROM m_rec_consume_copy b
LEFT JOIN OWN_ORG_STUDENT_TYPE t ON b.OUTID = t.OUTID
WHERE 1=1 AND b.class_code IN
('1681115542','1681115561','1681115562','1681115571','1681115572','1681115581','1681115582','1681115591','1681115592','1681115593','1681115594','1681115611','1681115612','1681115631','1681115951','1681115961','1681115971','1681115981','1681115991')
AND t.SCHOLARSHIP=1
GROUP BY b.outid
ORDER BY sums
LIMIT 10 OFFSET 2
2??jdbc api is error
SELECT b.outid, SUM(b.opfare) AS sums
FROM m_rec_consume_copy b
LEFT JOIN OWN_ORG_STUDENT_TYPE t ON b.OUTID = t.OUTID
WHERE 1=1 AND b.class_code IN
('1681115542','1681115561','1681115562','1681115571','1681115572','1681115581','1681115582','1681115591','1681115592','1681115593','1681115594','1681115611','1681115612','1681115631','1681115951','1681115961','1681115971','1681115981','1681115991')
AND t.SCHOLARSHIP=1
GROUP BY b.outid
ORDER BY sums
LIMIT ? OFFSET ?
