How to find the second largest value from a given coloumn

Answer 1

SELECT MAX( col )
FROM table
WHERE col < ( SELECT MAX( col )
FROM table );

Check this thread :
https://www.sololearn.com/Discuss/1616312/how-to-find-second-highest-salary-of-a-given-table-in-oracle-database

Answer 2

SELECT TOP(1) col FROM Table ORDER BY col ASC LIMIT 2