RANK 分區函數與SUM OVER一起使用 ... () OVER (ORDER BY sm DESC) FROM SumCte ) , RnkCte AS ( SELECT Department, Name, Score, rnk = RANK() OVER (PARTITION BY a.
確定! 回上一頁