1.rank()函数是分级函数,这个函数必须与over函数一起使用,否则会报"缺少窗口函数错误"。
2.sql:
SELECT A.EMPNO AS 员工编号,
A.SAL AS 薪资,
A.JOB AS 岗位,
rank() OVER(PARTITION BY A.JOB ORDER BY A.SAL DESC) AS 岗位薪资等级
FROM EMP A
1.rank()函数是分级函数,这个函数必须与over函数一起使用,否则会报"缺少窗口函数错误"。
2.sql:
SELECT A.EMPNO AS 员工编号,
A.SAL AS 薪资,
A.JOB AS 岗位,
rank() OVER(PARTITION BY A.JOB ORDER BY A.SAL DESC) AS 岗位薪资等级
FROM EMP A