To Find nth Max salary in employee table

DECLARE
SET @N int @N= 3SELECT * FROM employee E1 WHERE (@N-1) = (SELECT COUNT(DISTINCT(E2.employee ))FROM employee E2 WHERE E2.employee fid > E1.employee fid)