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 ·
3242 阅读 ·
0 评论