mysql查询结果分组后二次查询_2一、MySQL-分组查询（GROUP BY）及二次筛选（HAVING）...

mysql>

-- 按照性别分组，统计出每一个组中年龄最大值、最小值，薪水最大值，每一个组中的人数，人名，以及平均薪水。

mysql> SELECT id,sex,MAX(age) AS max_age,MIN(age) AS min_age,MAX(salary) AS max_salary,COUNT(*) AS total_peo,AVG(salary)

AS avg_salary ,GROUP_CONCAT(username)FROM employee GROUP BY sex;

+----+------+---------+---------+------------+-----------+-------------+-------------------------------+

| id | sex  | max_age | min_age | max_salary | total_peo | avg_salary  | GROUP_CONCAT(username)        |

+----+------+---------+---------+------------+-----------+-------------+-------------------------------+

|  1 | 男   |      62 |      21 |    9932.14 |         5 | 7492.278027 | 张三,李四,赵六,Mr Adword,孙八 |

|  3 | 女   |      45 |      26 |    9132.99 |         2 | 7532.955078 | 王五,Mr lili                  |

|  5 | 保密 |      19 |      19 |    4932.92 |         2 | 4932.919922 | 田七,田七                     |

+----+------+---------+---------+------------+-----------+-------------+-------------------------------+