lviswanath

 Profile Answers by lviswanath 

• Jul 17th, 2013

 

Code
SELECT deptno, MAX(sal) max_sal


FROM emp


GROUP BY deptno;