查询各个年龄段的人数:
mysql> select fage, count(*) from t_employee
-> group by fage;
+------+----------+
| fage | count(*) |
+------+----------+
| 22 | 1 |
| 23 | 2 |
| 25 | 2 |
| 27 | 1 |
| 28 | 3 |
+------+----------+
5 rows in set
查询每一分公司,各个年龄段的人数:
mysql> select fsubcompany,fage,count(*) from t_employee
-> group by fsubcompany,fage;
+-------------+------+----------+
| fsubcompany | fage | count(*) |
+-------------+------+----------+
| Beijing | 23 | 2 |
| Beijing | 25 | 2 |
| Beijing | 28 | 2 |
| ShenZhen | 22 | 1 |
| ShenZhen | 27 | 1 |
| ShenZhen | 28 | 1 |
+-------------+------+----------+
查询每个分公司每个月需要向员工支付工资总额:
mysql> select fsubcompany,sum(fsalary) from t_employee
-> group by fsubcompany;
+-------------+--------------+
| fsubcompany | sum(fsalary) |
+-------------+--------------+
| Beijing | 30801.24 |
| ShenZhen | 6300.80 |
+-------------+--------------+
2 rows in set
查询每个部门每个月需要向员工支付工资总额:
mysql> select fdepartment,sum(fsalary) from t_employee
-> group by fdepartment;
+---------------+--------------+
| fdepartment | sum(fsalary) |
+---------------+--------------+
| Development | 10600.80 |
| HumanResource | 7401.24 |
| InfoTech | 6700.00 |
| Sales | 12400.00 |
+---------------+--------------+
4 rows in set
查询每个部门员工年龄的最大值和最小值:
mysql> select fdepartment,min(fage),max(fage) from t_employee
-> group by fdepartment;
+---------------+-----------+-----------+
| fdepartment | min(fage) | max(fage) |
+---------------+-----------+-----------+
| Development | 25 | 28 |
| HumanResource | 23 | 25 |
| InfoTech | 27 | 28 |
| Sales | 22 | 28 |
+---------------+-----------+-----------+
4 rows in set