Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102903 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / basheer
ex:
Raj 200
kamal 300
hajka 500
Suresh 200
so 1st max salary is 500,2nd is 300,3rd is 200
we need 2nd maximum only(i.e 300)
Query is below
SELECT MIN(SALARY) FROM EMPLOYEE WHERE SALARY IN (SELECT
DISTINCT TOP 2 SALARY FROM EMPLOYEE ORDER BY SALARY DESC)
I've checked this query.
it will give 2nd maximum value.
if it is 3rd max salary then use TOP 3 instead of TOP 2
if u need detail explanation:
1)
Qry: SELECT DISTINCT TOP 2 SALARY FROM EMPLOYEE ORDER BY
SALARY DESC
Output:500
300
2)
SELECT MIN(SALARY) FROM EMPLOYEE WHERE SALARY IN (SELECT
DISTINCT TOP 2 SALARY FROM EMPLOYEE ORDER BY SALARY DESC)
ans: it gets minimum salary from subquery( from above 1st ans)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can instead of triggers be used to fire once for each statement on a view?
What are secondary keys?
what is text? : Sql dba
How to prepare for oracle pl sql certification?
What is schema in sql example?
What is a design view?
discuss about myisam index statistics collection. : Sql dba
what are the 'mysql' command line options? : Sql dba
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
What is asqueryable?
How does a trigger work?
what happens if you no create privilege in a database? : Sql dba
What is a natural join sql?
Can a commit statement be executed as part of a trigger?
What does <> sql mean?
