Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102858 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / kirti
Very simple answer: Arrange the top two salaries in
decending order. Select the mininum salary.
Select min(salary) from Employee where salary in(select top
2 salary from employee order by salary desc)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is an implicit commit?
What is an emotional trigger?
how do you know if your mysql server is alive? : Sql dba
How do you create an update query?
Why do we need unique key in a table?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
define data blocks ? : Sql dba
What are the benefits of stored procedures?
What is clustered and nonclustered index in sql?
How to read/write files from pl/sql?
Can a varchar be a primary key?
explain the difference between myisam static and myisam dynamic. : Sql dba
What is the difference between rename and alias?
What is trigger and types?
What are different types of functions in sql?
