Saturday 18 June 2011

How Can we Get dept wise max sal along with empname and emp no ?


Select a.empname, a.empno, b.sal, b.deptno 
From EMP a, (Select max (sal) sal, deptno from EMP group by deptno) b
Where a.sal=b.sal and a.deptno=b.deptno

No comments:

Post a Comment