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.

Utilisateur supprimé · 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;

Produits Par Bayt.com

Utilisez l'Appli de Bayt.com

Communiquez avec les autres et partagez vos connaissances professionnelles

How do I find second highest value from a table?

Recherches Populaires

More Questions Like This