oracle根据某个字段统计各个状态的比例
SELECT( CASE WHEN SOFTGATEWAY_POSLIST.POSSTATUS = 0 THEN '离线' WHEN SOFTGATEWAY_POSLIST.POSSTATUS = 1 THEN '在线' END ) status,COUNT( * ) rs,100 * round( COUNT( * ) / SUM( COUNT( * )) OVER (), 2 )...
·
SELECT
( CASE WHEN SOFTGATEWAY_POSLIST.POSSTATUS = 0 THEN '离线' WHEN SOFTGATEWAY_POSLIST.POSSTATUS = 1 THEN '在线' END ) status,
COUNT( * ) rs,
100 * round( COUNT( * ) / SUM( COUNT( * )) OVER (), 2 ) percent
FROM
SOFTGATEWAY_POSLIST
GROUP BY
CASE
WHEN SOFTGATEWAY_POSLIST.POSSTATUS = 0 THEN
'离线'
WHEN SOFTGATEWAY_POSLIST.POSSTATUS = 1 THEN
'在线'
END
结果展示:
更多推荐
已为社区贡献1条内容
所有评论(0)