有时候对于group by 的语句 会感到陌生,不知道运行起来会是怎么样的
SELECT department, gender, COUNT(*)
FROM employees
GROUP BY department, gender;
运行结果:
有时候对于group by 的语句 会感到陌生,不知道运行起来会是怎么样的
SELECT department, gender, COUNT(*)
FROM employees
GROUP BY department, gender;
运行结果: