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 <[EMAIL PROTECTED]> on 20.12.2001 13:18:49 Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
