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
What is trigger types of trigger?
What is mdb stand for?
What are the parameter modes supported by pl/sql?
What is indexing in sql and its types?
- 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?
What is the least restrictive isolation level? : Transact sql
What is use of term?
What is full form of rtm?
Can we commit in trigger?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What is pl sql code?
What is the purpose of the primary key?
What is before and after trigger?
Define concurrency control. : Transact sql
Can we create index on primary key?