How To Select The nth Highest Record In MySQL

SELECT 
    *
FROM
    table_name
ORDER BY column_name ASC
LIMIT N;