select x.* from (
SELECT SALARY, EMP_ID, RANK() OVER(ORDER By Salary) AS MAX_SALARY FROM employee) X
WHERE X.Max_salary = 5
Let's Learn
select x.* from (
SELECT SALARY, EMP_ID, RANK() OVER(ORDER By Salary) AS MAX_SALARY FROM employee) X
WHERE X.Max_salary = 5
No comments:
Post a Comment