Ritesh

Forum Replies Created

Viewing 1 post (of 1 total)
  • Author
    Posts
  • November 19, 2015 at 12:26 pm in reply to: How to retrieve 3rd Max salary from a table in sql server? #5153
    Ritesh
    Member

    you can also use Sql rank() function like :

    select Empname,Empsalary from (
    select Empname,Empsalary,rank() over (order by Empsalary desc) as ranking from tblemployee
    ) a
    where ranking = 3

    hope this helps….

  • Author
    Posts
Viewing 1 post (of 1 total)