select question of how to ?
2004-08-30 09:34:02
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>
|
- select question of how to ?,
Justin Case <=
|
|
|