select a.name from Customer a left join ( select id,sum(bal),rank() over (order by sum(bal) desc ) rk from Card group by id order by sum(bal)) b on a.id = b.id where rk = 1 and a.city = 'beijing'
1 2

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务