MySQL--GroupBy

mysql group by 用法解析(详细)_mysql group by用法_暴走的山交的博客-CSDN博客

---

SELECT DEPT, EDLEVEL, MAX( SALARY ) AS MAXIMUM
FROM staff
WHERE HIREDATE > '2010-01-01'
GROUP BY DEPT, EDLEVEL
ORDER BY DEPT, EDLEVEL

DEPT  EDLEVEL  MAXIMUM 
设计部    4    2300
设计部    5    2600
销售部    5    3000
销售部    7    3500

---

SELECT DEPT, MAX( SALARY ) AS MAXIMUM, MIN( SALARY ) AS MINIMUM
FROM staff
GROUP BY DEPT
HAVING COUNT( * ) >2
ORDER BY DEPT

查询结果如下：
  DEPT  MAXIMUM  MINIMUM 
  设计部  2600    2100
  销售部  3500    3000
---

SELECT DEPT, MAX( SALARY ) AS MAXIMUM, MIN( SALARY ) AS MINIMUM
FROM staff
GROUP BY DEPT
HAVING AVG( SALARY ) >3000
ORDER BY DEPT

查询结果如下：
  DEPT  MAXIMUM  MINIMUM 
  销售部   3500   3000
---