Nth Highest Salary

The Problem

Using LIMIT and OFFSET

-- 2nd highest salary (N=2, so OFFSET 1)
SELECT DISTINCT salary
FROM employees
ORDER BY salary DESC
LIMIT 1 OFFSET 1;

Using a Subquery

-- highest salary less than the maximum = 2nd highest
SELECT MAX(salary)
FROM employees
WHERE salary < (SELECT MAX(salary) FROM employees);

Summary

• For the Nth highest: ORDER BY salary DESC LIMIT 1 OFFSET (N-1).
• Use DISTINCT to skip duplicate salaries.

समस्या

LIMIT और OFFSET से

-- 2nd highest salary (N=2, तो OFFSET 1)
SELECT DISTINCT salary
FROM employees
ORDER BY salary DESC
LIMIT 1 OFFSET 1;

Subquery से

-- maximum से छोटी highest salary = 2nd highest
SELECT MAX(salary)
FROM employees
WHERE salary < (SELECT MAX(salary) FROM employees);

सारांश

• Nth highest के लिए: ORDER BY salary DESC LIMIT 1 OFFSET (N-1)।
• Duplicate salaries skip करने को DISTINCT use करें।