Write a query to get 2nd maximum salary in an employee table ?

Answer Posted / lalit raghuvanshi

I got the solution:
Multiple Sql server queries to get second,third,fourth or nth highest/maximum salary from employee table
http://www.webcodeexpert.com/2014/08/sql-server-query-to-get.html

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is trigger types of trigger?

562


What is mdb stand for?

565


What are the parameter modes supported by pl/sql?

545


What is indexing in sql and its types?

558


- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1395






What is the least restrictive isolation level? : Transact sql

573


What is use of term?

630


What is full form of rtm?

543


Can we commit in trigger?

556


Lookups are a key component in sql server integration services (ssis). Explain its purpose?

555


What is pl sql code?

609


What is the purpose of the primary key?

578


What is before and after trigger?

530


Define concurrency control. : Transact sql

593


Can we create index on primary key?

537