Oracle Query Math

Giganews Newsgroups
Subject: Oracle Query Math
Posted by:  trpo…@gmail.com
Date: Thu, 29 Nov 2007

I have a query:

SELECT GROUP_NAME, PERCENT FROM GROUPSUMMARY
WHERE REPORT_DATE= TO_DATE( '2007-10-01','YYYY-MM-DD')
ORDER BY PERCENT DESC;

I get results like this:

Group1    40
Group2    20
Group3    15
Group4    10
Group5    5
Group6    4
Group7    3
Group8    2
Group9    1

What I want is a query that returns the top 5 rows and then a sixth
row with a calculation that is the sum of any result rows past row 5,
which could be variable.

So I want the results to show this:

Group1    40
Group2    20
Group3    15
Group4    10
Group5    5
Other      10

Where "Other" is 100-(sum of rows 1-5).

Is this possible with a query? This is an Oracle 10G database, not
sure about the patch level. Thanks for your help!

Replies