Nth Highest Salary
CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
put limit N, 1 not N-1
it's remarkable. thanks!
ifnull seems to be redundant
It's not clear why you had to use another variable M and set to N-1, rather than just using N-1 directly in the limit clause. I know that causes an error, but why exactly?
No one has replied
w3c sql top
guess you cannot do calculations within "LIMIT x,y"
Disabled Categories are greyed out
Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.