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.
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2004