mysql中这样写GROUP BY和count居然不会出错？

最新推荐文章于 2023-04-27 15:52:19 发布

程宇寒

最新推荐文章于 2023-04-27 15:52:19 发布

阅读量486

点赞数

本文链接：https://blog.csdn.net/czh500/article/details/107144770

版权

SELECT * FROM salary;
SELECT deptId, MAX(sal) FROM salary;
SELECT empId, deptId, MAX(sal) FROM salary;
SELECT deptId, MAX(sal), AVG(sal) , MIN(sal) FROM salary GROUP BY deptId;
SELECT empId, deptId, MAX(sal) FROM salary GROUP BY deptId;
SELECT empId, deptId, MIN(sal) FROM salary GROUP BY deptId;
SELECT empId, deptId, AVG(sal) FROM salary GROUP BY deptId;
SELECT empId, deptId, SUM(sal) FROM salary GROUP BY deptId;
SELECT empId, deptId, COUNT(sal) FROM salary GROUP BY deptId;
SELECT * FROM salary;
SELECT
	COUNT(*),
	COUNT(1),
	COUNT(66),
	COUNT(88),
	COUNT(empId),
	COUNT(deptId),
	COUNT(sal),
	COUNT('aaa'),
	COUNT('bbb'),
	COUNT(0),
	COUNT(NULL)
FROM
	salary;