select node_name,sum(physical_mb) as "Physical",sum(logical_mb) as
"Logical" -
from occupancy -
group by node_name

Zlatko Krastev
IT Consultant





Robert Ouzen <rouzen AT UNIV.HAIFA.AC DOT IL> on 20.12.2001 13:18:49
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To:     ADSM-L AT VM.MARIST DOT EDU
cc:

Subject:        Select command

Hi

Did anybody know how to calculate with a select command the sum of all my Q
OCC ??????

Thanks Robert Ouzen
E-Mail: rouzen AT univ.haifa.ac DOT il