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.

مستخدم محذوف‎ · 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;

خدمات بيت.كوم

استخدم تطبيق بيت.كوم

ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

How do I find second highest value from a table?

عمليات البحث الشائعة

المزيد من الأسئلة المماثلة