如何找到列的第n个最大值?

本文介绍了如何找到列的第n个最大值?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

是否存在类似于以下命令:

Is there a command akin to:

• 2nd highest salary from tbl_salary或

4th highest salary from tbl_salary吗?

我看过:

select salary from tbl_salary t where &n = ( select count(salary) from( select distinct salary from tbl_salary )where t.salary<=salary );

它如何工作?

还有其他简单的方法可以得到结果吗?

Are there other simple ways to get result?

推荐答案

如果是基本查询，则只需使用LIMIT:

If it's a basic query, then just use LIMIT:

-- get the 4th highest salary SELECT salary FROM tbl_salary ORDER BY salary DESC LIMIT 3,1