By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table employee(
salary int
);
insert into employee values
(1),
(2),
(3),
(4),
(5),
(6),
(7),
(8),
(5000),
(5000),
(3000);
WITH cte AS
(
SELECT *,
DENSE_RANK() OVER (ORDER BY salary Desc) AS Rnk
FROM employee
)
SELECT cte.salary
FROM cte
WHERE Rnk=2;
| salary |
|---|
| 3000 |