Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Avg problem
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
![]() |
![]() |