how to get second height salary in Sql Server





select max(salary) from EMP where salary <(select max (salary)from EMP)


Out Put :-


ID (PK)
Salary
5
17000

how to get second height salary in Sql Server how to get second height salary in Sql Server Reviewed by NEERAJ SRIVASTAVA on 6:47:00 PM Rating: 5

2 comments:

  1. hi sir
    i want to add some event like birthday,anniversary day in my table we have some table so how to do it

    ReplyDelete
    Replies
    1. please check below links , it will help you

      http://www.neerajcodesolutions.com/2015/01/how-to-show-today-birthday.html

      http://www.neerajcodesolutions.com/2014/12/how-to-show-birthday-reminder-in-aspnet.html

      let me know if any issues

      Delete

Powered by Blogger.