select cardid from 表 where money =
(select max(money) as money from 表)
--------------修改------------
select c.cardid from
(select max(a.money) money from
(select cardid,sum(money) money from 表 group by cardid) a) b,
(select cardid,sum(money) money from 表 group by cardid) c
where b.money=c.money
本文如未解决您的问题请添加抖音号:51dongshi(抖音搜索懂视),直接咨询即可。