SQL query to find nth maximum element

• Use ORDER BY clause to sort the elements in descending order

• Use LIMIT to select the nth element

• Use subquery to exclude the first n-1 elements