By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
-- creating Employee table in Oracle
CREATE TABLE Employee (name varchar(10), salary int);
-- inserting sample data into Employee table
INSERT INTO Employee VALUES ('Rick', 3000);
INSERT INTO Employee VALUES ('John', 4000);
INSERT INTO Employee VALUES ('Shane', 3000);
INSERT INTO Employee VALUES ('Peter', 5000);
INSERT INTO Employee VALUES ('Jackob', 7000);
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 1 salary FROM Employee ORDER BY salary DESC
) AS temp
ORDER BY salary
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 2 salary FROM Employee ORDER BY salary DESC
) AS temp
ORDER BY salary
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary FROM Employee ORDER BY salary DESC
) AS temp
ORDER BY salary
| salary |
|---|
| 7000 |
| salary |
|---|
| 5000 |
| salary |
|---|
| 4000 |