大家好,
我建了一个表,有两个字段sname,salary
里面有10个数据:
+-------------+--------+
| sname | salary |
+-------------+--------+
| SYL | 1800 |
| WBB | 1800 |
| MTT | 1600 |
| RG | 1500 |
| SB | 2500 |
| WBB | 1000 |
| SB | 500 |
| SYL | 400 |
| RG | 600 |
| MTT | 800 |
+-------------+--------+
现在我用了一个语句得到了这样一个结果mysql> select sname,sum(salary) from money group by sname;
+-------------+-------------+
| sname | sum(salary) |
+-------------+-------------+
| MTT | 2400 |
| RG | 2100 |
| SB | 3000 |
| SYL | 2200 |
| WBB | 2800 |
+-------------+-------------+
请问大家,如果我要得到一个最大值的返回结果,该怎么写呢,下面是我写的语句,提示有错误:
mysql> select sname,max(sum(salary)) from (select sname,sum(salary) from money group by sname) as tb;
ERROR 1111 (HY000): Invalid use of group function急切盼望大家回复,谢谢大家!!!!
我建了一个表,有两个字段sname,salary
里面有10个数据:
+-------------+--------+
| sname | salary |
+-------------+--------+
| SYL | 1800 |
| WBB | 1800 |
| MTT | 1600 |
| RG | 1500 |
| SB | 2500 |
| WBB | 1000 |
| SB | 500 |
| SYL | 400 |
| RG | 600 |
| MTT | 800 |
+-------------+--------+
现在我用了一个语句得到了这样一个结果mysql> select sname,sum(salary) from money group by sname;
+-------------+-------------+
| sname | sum(salary) |
+-------------+-------------+
| MTT | 2400 |
| RG | 2100 |
| SB | 3000 |
| SYL | 2200 |
| WBB | 2800 |
+-------------+-------------+
请问大家,如果我要得到一个最大值的返回结果,该怎么写呢,下面是我写的语句,提示有错误:
mysql> select sname,max(sum(salary)) from (select sname,sum(salary) from money group by sname) as tb;
ERROR 1111 (HY000): Invalid use of group function急切盼望大家回复,谢谢大家!!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货