select max(count(department_id))
from staff
group by department_id ERROR at line 4:
ORA-00918: column ambiguously defined Select department_name
from staff s
inner join department d on s.department_id=d.department_id
having count(s.department_id) in (Select max(count(department_id))
from staff) group by department_id-预期输出
DEPARTMENT_NAME
------------------------------
SE
```none-输出差异
(select max(count(Department_id) from staff))按departmentDEPARTMENT_idNAME分组
*------------------------------ 第4行的SERROR:
ORA-00918:列定义不明确
测试总结
+
2次测试运行/0次测试通过
+
发布于 2020-09-30 22:07:53
SELECT department_name
FROM department
WHERE department_id IN
(SELECT department_id
FROM staff
HAVING COUNT(department_id) IN
(SELECT MAX(COUNT(department_id))
FROM staff
GROUP BY department_id)
GROUP BY department_id);https://stackoverflow.com/questions/57045273
复制相似问题