es group by max并显示非group by 的其他字段
一.sql 示例
假设有如下数据
SELECT
"1" as id,"001" as card,1 as sequenceNo, 1 as resultStatus
UNION ALL
SELECT
"2" as id,"001" as card,2 as sequenceNo, 2 as resultStatus
UNION ALL
SELECT
"3" as id,"001" as card,3 as sequenceNo, 3 as resultStatus
UNION ALL
原创
2022-03-03 10:11:51 ·
3438 阅读 ·
0 评论