sql求平均秩序

SELECT callinamount,AVG(n*1.0)OVER(PARTITION BY r)

FROM 

(

SELECT  callinamount ,

        (RANK() OVER ( ORDER BY callinamount )) r ,

        (ROW_NUMBER() OVER ( ORDER BY callinamount )) n

FROM    #t

) a

ORDER BY callinamount