compute Results Appear as a New Row or Rows

The aggregate functions ordinarily produce a single value for all the selected rows in the table or for each group, and these summary values are shown as new columns.

For example:
select type, sum (price), sum (advance) 
from titles 
where type like "%cook" 
group by type 
type 
-------------  ---------  ---------- 
mod_cook           22.98  15,000.00 
trad_cook          47.89  19,000.00

 (2 rows affected)
The compute clause allows you to retrieve detail and summary rows with one command. For example:
select type, price, advance
from titles 
where type like "%cook" 
order by type 
compute sum (price), sum (advance) by type
type        price       advance 
----------  ----------  ---------------- 
mod_cook          2.99         15,000.00 
mod_cook         19.99              0.00 

Compute Result: 
---------------------- -----------------
                 22.98         15,000.00 
type         price         advance 
----------  ----------  ---------------- 
trad_cook        11.95          4,000.00 
trad_cook        14.99          8,000.00 
trad_cook        20.95          7,000.00 

Compute Result: 
---------------------- -----------------
                 47.89         19,000.00 
 (7 rows affected) 

The output and grouping of different types of compute clauses are:.

Clauses and Grouping

Output

Examples

One compute clause, same function

One detail row

1, 2, 4, 6, 7

One compute clause, different functions

One detail row per type of function

3

More than one compute clause, same grouping columns

One detail row per compute clause; detail rows together in the output

Same results as having one compute clause with different functions

More than one compute clause, different grouping columns

One detail row per compute clause; detail rows in different places, depending on the grouping

5