Hi Srinivas, SELECT DEPTNO , MIN(SAL) OVER (PARTITION BY DEPTNO) MINSAL, MAX(SAL) OVER (PARTITION BY DEPTNO) MAXSAL FROM EMP ; I have not included ENAME , but hope this this is the way to go for ur query. Regards, Prem. -- //www.freelists.org/webpage/oracle-l