sql中需要用到： Row_Number() OVER (partition by a ORDER BY count(*) desc) ，但提示“此处不能应用窗口函数，如何解决，请老师们指点！”
count(*)不能在order by 后面使用，你要么就再套一层
SELECT
A.C AS 处理数量,
A.实际处理人,
ROW_NUMBER() OVER (PARTITION BY A.FINISHAT ORDER BY A.C DESC) AS R,
A.FINISHAT
FROM (
select
count(*) as C,
N2.DISPLAY 实际处理人,
SUBSTR(T.FINISHAT,1,10) AS FINISHAT
from ......
....) A
把count(*)删了试试，开窗分析不能和分组一块用吧
1min目标场景问卷
立即参与
”
