Davan Polampalli Davan Polampalli - 12 days ago 5
MySQL Question

How to get the fourth highest value using sql query

I have student table which has column of score. I want to get the fourth highest score,Where the table data is sorted in ascending order.

Answer
SELECT score FROM table ORDER BY score ASC LIMIT 1 OFFSET 4 

hope this works, happy coding