Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

Re: query problem

From: "Prem Khanna J" <premj@xxxxxxxxxxxxxx>
To: "Srinivas T" <SrinivasT@xxxxxxxxxxxxxxx>
Date: 26 Aug 2004 07:10:39 -0000

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-l

Other related posts:

Re: query problem

query problem

RE: query problem