Davan Polampalli Davan Polampalli - 11 months ago 65
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 Source
SELECT score FROM table ORDER BY score ASC LIMIT 1 OFFSET 4 

hope this works, happy coding