mysql查询工资前十名_MYSQL查询以找到薪水第n高的所有员工

The two tables are salary_employee and employee

employee_salary

salary_id emp_id salary

Employee

emp_id | first_name | last_name | gender | email | mobile | dept_id | is_active

Query to get the all employees who have nth highest salary where n =1,2,3,... any integer

SELECT a.salary, b.first_name

FROM employee_salary a

JOIN employee b

ON a.emp_id = b.emp_id

WHERE a.salary = (

SELECT salary

FROM employee_salary

GROUP BY salary

DESC

LIMIT 1 OFFSET N-1

)

My Questions:

1) Is there any better and optimized way we can query this,

2) Is using LIMIT an good option

3) We have more options to calculate the nth highest