How do I find second highest value from a table?

Question

Hazem Qannash · Answer

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.

Deleted user · Answer

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

Mostafa Shamout · Answer

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

marwa khalaf · Answer

You can write as following :

select min(ID) from Table  limit 2

nithin koshy · Answer

SELECT TOP 2 FROM TABLE

ORDER BY DESC;

Products By Bayt.com

Use Our Mobile App

Start networking and exchanging professional insights

How do I find second highest value from a table?

Popular Searches

More Questions Like This