Use Different Aggregates in the Aame compute Clause

You can use different aggregates in the same compute clause.

select type, pub_id, price 
from titles 
where type like "%cook" 
order by type, pub_id 
compute sum(price), max(pub_id) by type 
type        pub_id  price 
----------- ------- --------------
mod_cook    0877             2.99 
mod_cook    0877            19.99 
 
Compute Result:
--------------- ----
          22.98 0877 
 
type        pub_id  price 
----------- ------- --------------
trad_cook   0877            11.95 
trad_cook   0877            14.99 
trad_cook   0877            20.95 
 
Compute Result:
--------------- ----
          47.89 0877
 
(7 rows affected)