Hi I can't do this command how can I do it? ? SELECT MAX( Avg(sal) ),deptno FROM emp Group by deptno;

Question

,ORACLE DataBase

Answer 1

Your sql statement looks fine, no syntax errors. Does the table exist in your database? What is the error you are getting?

Answer 2

Assuming you are trying to get the max of all the average sal, this should work

SELECT MAX(avgsal)
FROM (SELECT AVG(sal) AS avgsal, deptno
FROM emp
GROUP BY deptno) AS avgEmp

Answer 3

Oh yes i forrget some thing in my Quastion

Answer 4

SELECT MAX(Avg(sal) ) ,deptno
FROM emp
Group by deptno;

Answer 5

All thinks, if you know another method it's good i need it