2nd highest value in sql
-- 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 2 salary FROM Employee ORDER BY salary DESC ) AS temp ORDER BY salary
Source: dbfiddle.uk