Why is "SELECT DISTINCT Salary FROM Employee ORDER BY Salary DESC LIMIT N1, 1" wrong?
Why is "SELECT DISTINCT Salary FROM Employee ORDER BY Salary DESC LIMIT N1, 1" wrong?

According to MySQL reference manual,
LIMIT
parameters can only be specified by(1) nonnegative integer constants,
(2) placeholder?
in prepared statement,
(3) integervalued routine parameters or local variables in stored program.So expression
N1
is not allowed here.