Select DEPARTMENTID,EMPLOYEENAME,SALARY, RANK() OVER ( Partition By DEPARTMENTID Order By SALARY Desc) "不跳号排名", DENSE_RANK() OVER ( Partition By DEPARTMENTID Order By SALARY Desc ) "跳号排名", From EMPLOYEEINFO
不跳号: SELECT salary,Dense_Rank() over (PARTITION BY dept ORDER BY salary desc) FROM t; 跳号: SELECT salary,Rank() over (PARTITION BY dept ORDER BY salary desc) FROM t;
RANK() OVER ( Partition By DEPARTMENTID Order By SALARY Desc) "不跳号排名",
DENSE_RANK() OVER ( Partition By DEPARTMENTID Order By SALARY Desc ) "跳号排名",
From EMPLOYEEINFO
SELECT salary,Dense_Rank() over (PARTITION BY dept ORDER BY salary desc) FROM t;
跳号:
SELECT salary,Rank() over (PARTITION BY dept ORDER BY salary desc) FROM t;