select 1,
' less than 1 minute' During,
count(*) as Num,
count(*) / 45637 * 100 as Percentage
from al_history
where clear_during < 60
union
select 2,
'1-5 minute' During,
count(*) as Num,
count(*) / 45637 * 100 as Percentage
from al_history
where clear_during >= 60
and clear_during < 300
union
select 3,
'5-10 minute' During,
count(*) as Num,
count(*) / 45637 * 100 as Percentage
from al_history
where clear_during >= 300
and clear_during < 600
union
select 4,
'more than 10 minutes' During,
count(*) as Num,
count(*) / 45637 * 100 as Percentage
from al_history
where clear_during >= 600
' less than 1 minute' During,
count(*) as Num,
count(*) / 45637 * 100 as Percentage
from al_history
where clear_during < 60
union
select 2,
'1-5 minute' During,
count(*) as Num,
count(*) / 45637 * 100 as Percentage
from al_history
where clear_during >= 60
and clear_during < 300
union
select 3,
'5-10 minute' During,
count(*) as Num,
count(*) / 45637 * 100 as Percentage
from al_history
where clear_during >= 300
and clear_during < 600
union
select 4,
'more than 10 minutes' During,
count(*) as Num,
count(*) / 45637 * 100 as Percentage
from al_history
where clear_during >= 600
解决方案 »
- 要支持oracle mssql mysql db2等多个数据库,大家是怎么维护脚本的啊?
- 求 在windows 2008 server 64位 企业版上安装oracle 方法?
- 求帮忙,关于SQL文方面的。
- 求教一个sql语句
- 请问个关于ascii的问题
- 求一约束的实现方式,急,在线等
- 请教:用PL/SQL Develop工具从Excel中导入数据记录到Oracle9i下出错(ORA-00928)
- 在OEM中怎么连接另外一个数据库?
- oracle中有没有查找字符串的函数
- java.sql.SQLException: 指定了无效的 Oracle URL
- 在oracle数据库中,如何建立两帐数据表的主外键关系?
- JAVA读取文本文件,然后执行该SQL语句,出现java.sql.SQLException: ORA-00911: invalid character报错
SELECT SID,
DURING,
COUNT(1) "NUM",
COUNT(1)/4563700 "PERCENTAGE"
FROM (
SELECT (CASE WHEN CLEAR_DURING < 60
THEN 1
WHEN CLEAR_DURING >= 60 AND CLEAR_DURING < 300
THEN 2
WHEN CLEAR_DURING >= 300 AND CLEAR_DURING < 600
THEN 3
WHEN CLEAR_DURING >= 600
THEN 4
ELSE 0
END) "SID",
(CASE WHEN CLEAR_DURING < 60
THEN 'LESS THAN 1 MINUTE'
WHEN CLEAR_DURING >= 60 AND CLEAR_DURING < 300
THEN '1-5 MINUTE'
WHEN CLEAR_DURING >= 300 AND CLEAR_DURING < 600
THEN '5-10 MINUTE'
WHEN CLEAR_DURING >= 600
THEN 'MORE THAN 10 MINUTES'
ELSE 0
END) "DURING"
FROM AL_HISTORY
)TT
GROUP BY SID,DURING;