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
解决方案 »
- 怎样在表的指定位置插入记录?
- select count(*) into int_int from PAN_IntegralSpoilSet i where i.activitycid=
- 这么简单都有错??
- 关于ORA-01405
- 请教两个SQL语句不同Cost的原因
- 转换问题
- 高手来帮个忙,怎么在Oracle数据库中实现转换???
- 为什么我的client端连不上数据库
- ORA-03113: 通信通道的文件结束
- 一上午都没有结果,关于导入问题
- 在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;