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