How do I find second highest value from a table?

You can use this query: select distinct points from table order by points desc offset 1 limit 1; to return the second highest value from the table.

I think this is the most straight forward solution..
SELECT MAX( col ) FROM table WHERE col < ( SELECT MAX( col ) FROM table )

SELECT salary_amount FROM (select salary2.*, rownum rnum from (select * from salary ORDER BY salary_amount DESC) salary2 where rownum = 2;

You can write as following : select min(ID) from Table limit 2

SELECT TOP 2 FROM TABLE

ORDER BY <COLUMN_NAME> DESC;