deeprashi

 Profile Answers by deeprashi 

• Mar 1st, 2010

 

SELECT max(sal), job FROM emp GROUP BY job

deepikazain

 Profile Answers by deepikazain Questions by deepikazain

• Mar 3rd, 2010

 

SELECT MAX(AVG(salary)) FROM employee GROUP BY emp_id

taaznyonker

 Profile Answers by taaznyonker 

• Mar 31st, 2010

 

If you want to get only highest average salary of particular dept, then you can use

SELECT MAX(AVG(sal)) FROM emp GROUP BY deptno

and if want the dept number too, with the average sal, then query ould look like:

SELECT deptno, AVG(sal)
FROM emp
GROUP BY deptno
HAVING AVG(sal) = (SELECT MAX(AVG(sal)) FROM emp GROUP BY deptno)

Shubham kumar

• Oct 21st, 2021

 

Hope, This Will Help

Code
SELECT AVG(sal) FROM emp 


 GROUP BY job_id 


ORDER BY AVG(sal) LIMIT 1;