统计一张表中部分数据占总数的比例,使用over。
SELECT Typ
,COUNT(1)
,(COUNT(1) / SUM(COUNT(1)) Over()) Percent1
FROM (SELECT Decode(Sign(Xwat.Pending_Count - i.Warn_Count), 1, 'WARN', 0, 'WARN', 'NO WARN') Typ
FROM Xxcus_Warning_Admincount_t Xwat
WHERE Xwat.Query_Date BETWEEN (SYSDATE - (i.Warn_Time * 60 * 24)) AND SYSDATE
AND Xwat.Concurrent_Queue_Id = i.Concurrent_Queue_Id) a
GROUP BY Typ