Davan Polampalli Davan Polampalli - 1 month ago 8
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