Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Avg problem

Avg problem

From: Russell Kingham <kingham_at_yebo.co.za>
Date: 2000/06/09
Message-ID: <8hreeh$sf5$1@ctb-nnrp2.saix.net>#1/1 






Hi


I have to calculate an average of the 5 highest salaries and the average of
the 5 lowest salaries per job category. Is it possible to do this in one
query or do I have to use PL/SQL?


Thanks
Received on Fri Jun 09 2000 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US