Oracle SQL错误：ORA-00937：不是单组功能

Question

create or replace view DeptInfo as 
select dnumber, dname, AVG(salary), max(salary), min(salary) 
from department, employee; 

我环顾四周，尝试了Group By的组合试图弄清楚这一点。对不起，我的公民，只是一个可怜的学生。

dnumber和dname来自部门表，而薪水来自employee表。

Answer 1

你的问题不是很清楚..哪些表是来自哪些字段？

，你将需要有子查询，为您3个字段，因为它们都需要通过条款组

像

create or replace view DeptInfo as 
SELECT q1.dnumber, 
     q1.dname, 
     q1.AvgSal, 
     q2.MaxSal, 
     q3.MinSal 
FROM (SELECT dnumber, dname, AVG(salary) as AvgSal 
     FROM department, employee 
     GROUP BY dnumber, dname) q1, 
     (SELECT dnumber, dname, MAX(salary) as MaxSal 
     FROM department, employee 
     GROUP BY dnumber, dname) q2, 
     (SELECT dnumber, dname, MIN(salary) as MinSal 
     FROM department, employee 
     GROUP BY dnumber, dname) q3 
WHERE q1.dnumber = q2.dnumber AND 
     q2.dnumber = q3.dnumber AND 
     q1.dname = q2.dname AND 
     q2.dname = q3.name 

编辑：莫名其妙......忘记了分组依据，...