oracle dense_rank, select into
\nCREATE FUNCTION getNthHighestSalary(N IN NUMBER) RETURN NUMBER IS\nresult NUMBER;\nBEGIN\n    /* Write your PL/SQL query statement below */\n    select max(Sa
```\nCREATE FUNCTION getNthHighestSalary(N IN NUMBER) RETURN NUMBER IS\nresult NUMBER;\nBEGIN\n    /* Write your PL/SQL query statement below */\n    select max(Salary) into result\n    from\n        (select Salary, dense_rank() over(order by Salary desc) as rank\n        from Employee) tb1 \n    where tb1.rank = N;\n    RETURN result;\nEND;\n```
[]