Query for find Nth maximum value in Mysql

Question

How do I write a query to find the N^th maximum value in MySQL?

Answer 1

The Maximum Value for a Column:

SELECT MAX([column_name]) AS [alias] FROM [table_name];