Drop the group by clause...

Thanks, Chuck.

Chuck Hamilton
IBM Global Services - ITS
DCC II/EDDB/TSM
chuck.hamilton AT wachovia DOT com
hamilcha AT us.ibm DOT com
Wachovia Cube: 704-427-6506 (3B2-5D01)
Mobile Phone: 704-258-4930



Justin Case <justin.case AT DUKE DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
08/30/2004 09:26 AM

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 question of how to ?






Have a question on a select statement listed below..
How can I get a Total MB of all the backups in a column named Total ?
Thanks
Justin

'select entity as "Node
" ,                  cast( sum(bytes)/1024/1024 as decimal(9,0) ) as MB
from summary where (activity='BACKUP' or activity='ARCHIVE') and
cast((current_timestamp-end_time)hours as decimal)<24 group by entity
ORDER
by MB desc'

Node                                           MB
---------------------------------     -----------
BREMEN_BCV                                 596719
PRDB00_ORACLE_BWP                           60896
BREMEN                                      17812

ForwardSourceID:NT0002145A