获取MySQL表中的第二个最大值[关闭]

这是关系的原因。

Name    SalaryJim       6Foo       5Bar       5Steve     4SELECt name, salaryFROM employeesWHERe salary = (SELECt MAX(salary) FROM employees WHERe salary < (SELECt MAX(salary) FROM employees))Result --> Bar 5, Foo 5

编辑： 我接受了Manoj的第二篇文章，对其进行了调整，并使它更具可读性。对我来说 n-1 不直观；但是，使用我想要的值是2 =
2nd，3 = 3rd等。

SELECt name,salary FROM employeesWHERe salary = (SELECt DISTINCT(salary) FROM employees as e1WHERe (SELECt COUNT(DISTINCT(salary))=2 FROM employees as e2WHERe e1.salary <= e2.salary)) ORDER BY nameResult --> Bar 5, Foo 5