支行信息 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 ;
切记,一定要添加别名,否则会报错。