SELECT Name,Salary FROM ( SELECT ROW_NUMBER() OVER (ORDER BY salary DESC) AS RowNumber, Name, Salary FROM yourTable ) AS Demo WHERE RowNumber= 3
limit
select * from tablename order by salary desc limit 1, 3
Select * From Employee E1 Where (N-1) = (Select Count(Distinct(E2.Salary)) From Employee E2 Where E2.Salary > E1.Salary)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Submit an article or tip