按照age分组然后选择公司数量最大为800000之上的元组,则我们得到
mysql> select age,max(salary) from user1 group by age having max(salary)>800000;-- having子句可以对过滤后的数据进行处理,但是having子句不能单独使用,不能代替where,必须和group by子句联合使用
+-----+-------------+
| age | max(salary) |
+-----+-------------+
| 900 | 90000000 |
+-----+-------------+
1 row in set (0.00 sec)
mysql> select age,max(salary) from user1 where salary>800000 group by age;-- 优化,先用where进行条件过滤,然后group by。能用where尽量先用where
+-----+-------------+
| age | max(salary) |
+-----+-------------+
| 900 | 90000000 |
+-----+-------------+
1 row in set (0.00 sec)