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