sql 语句 MAX()+SUM() 使用

支行信息 branch(branch_name,branch_city)

账户信息 account(account_name,branch_name,balance)

查询 存款最多的支行

1.取巧的方法

SELECT SUM(a.balance),a.branch_name FROM account a,branch b WHERE a.branch_name=b.branch_name GROUP BY a.branch_name ORDER BY SUM(a.balance) DESC;
排序查询出所有。取第一条

2.正确方法

SELECT MAX(c.maxbaleance) FROM (SELECT SUM(a.balance) maxbaleance,a.branch_name FROM  account a,branch b WHERE a.branch_name=b.branch_name GROUP BY a.branch_name ORDER BY SUM(a.balance) DESC) c ; 
 

切记，一定要添加别名，否则会报错。