每日一刷
获赞
59
粉丝
4
关注
12
看过 TA
55
男 门头沟学院 2022 Java IP属地：天津暂未填写个人简介
2021-08-29 22:03
门头沟学院 Java 牛客63313070...：我写了个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)
投递渤海银行等公司10个岗位0 点赞 评论 收藏
分享
创作者周榜
更多
关注他的用户也关注了：