ADSM-L

select question of how to ?

2004-08-30 09:34:02
Subject: select question of how to ?
From: Justin Case <justin.case AT DUKE DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 30 Aug 2004 09:26:19 -0400
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

<Prev in Thread] Current Thread [Next in Thread>