如何找到列的第n个最大值? [英] How to find n'th highest value of a column?

问题描述

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

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

这篇关于如何找到列的第n个最大值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！