| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: query problem
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 28 2004 - 08:58:05 CDT
 |
 |