第一个s q l:
SELECT
oppty_id,
MAX(process_stage_id) recentStage
FROM
tr_opportunity_advance
GROUP BY
oppty_id
HAVING
recentStage = 928494872632102912
查不出结果
第二个sql:只是将having值变为字符串:SELECT oppty_id, MAX(process_stage_id) recentStage FROM tr_opportunity_advance GROUP BY oppty_id HAVING recentStage = '928494872632102912',
查询出: recentStage=928494872632102913 的两条结果
数据表中process_stage_id字段为20位bigint。正确处理应该是第一个sql,只是不明白第二个为什么会有值