Home Interview Questions & Answer Sql Server how to get second height salary in Sql Server

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. UnknownMarch 2, 2016 at 11:48 PM

    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. NEERAJ SRIVASTAVAMarch 3, 2016 at 11:12 AM

      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

Subscribe to: Post Comments ( Atom )
Powered by Blogger.