SQL OFFSET is 0-based, but N (1st, 2nd, 3rd highest) is 1-based
Eg:
N = 1 → OFFSET = 0 (highest salary)
N = 2 → OFFSET = 1 (2nd highest salary)
Write a
#SQL to find the nth highest distinct salary from the Employee table. If there are less than n distinct salaries, return null