sql连续排序DENSE

xiaoxiao2021-03-01  18

SELECT creatordepid, DENSE_RANK() OVER (ORDER BY COUNT(creatordepid) DESC) AS MC, CASE DENSE_RANK() OVER (ORDER BY COUNT(creatordepid) DESC) WHEN 1 THEN 100 ELSE 100 - (DENSE_RANK() OVER (ORDER BY COUNT(creatordepid) DESC) - 1) * 5 END FS FROM destask GROUP BY creatordepid

 

转载请注明原文地址: https://www.6miu.com/read-3350265.html

最新回复(0)