SQL查询从薪水表中找到第N个最高薪水 [英] SQL query to find Nth highest salary from a salary table

问题描述

有人帮助我从MYSQL的薪水表中找出第n个最高薪水

some one help me to find out nth highest salary from the salary table in MYSQL

推荐答案

尝试一下，n将是您要返回的第n个项目

Try this, n would be the nth item you would want to return

 SELECT DISTINCT(Salary) FROM table ORDER BY Salary DESC LIMIT n,1

这篇关于SQL查询从薪水表中找到第N个最高薪水的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！