mysql - 查询在Mysql中查找第N个最大值

Question

如何在 MySQL 中编写查询来查找第 N 个最大值？

Answer 1

SELECT column FROM table ORDER BY column DESC LIMIT (n-1), 1

看看http://php.about.com/od/mysqlcommands/g/Limit_sql.htm阅读 LIMIT on SQL:

Definition: Limit is used to limit your MySQL query results to those that fall within a specified range. You can use it to show the first X number of results, or to show a range from X - Y results. It is phrased as Limit X, Y and included at the end of your query. X is the starting point (remember the first record is 0) and Y is the duration (how many records to display).