我写了个https://blog.csdn.net/weixin_44296768/article/details/119994669?spm=1001.2014.3001.5501 SELECT NAME as 'Customer Name' from Customer left join Card ON Customer.ID=Card.ID where CITY='beijing' GROUP BY customer.NAME having sum(BAL)= (SELECT temp.s from (select NAME,sum(BAL) as s from Customer left join Card ON Customer.ID=Card.ID where CITY='beijing' group by NAME order by s desc limit 1) as temp)