Create a query using “ group by” that shows maximum salary for each department?

lviswanath

 Profile Answers by lviswanath Questions by lviswanath

• Jul 17th, 2013

Code
SELECT deptno, MAX(sal) max_sal
FROM emp
GROUP BY deptno;

Answer Question  Select Best Answer