- 博客(1)
- 收藏
- 关注
原创 MySQL中only_full_group_by报错解决方案
1. 问题来源以deptno分组查询,显示每组sal的最大值以及对应enameSELECT ename, MAX(sal), deptno FROM emp GROUP BY deptno;error:1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db01.emp.ename' which is not functionally depende
2022-05-30 21:25:48
658
1
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人