Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118293 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 clause?
What is sqlerrd?
What is difference between sql and mysql?
Why is there a need for sqlcode and sqlerrm variables?
What is trigger explain it?
Can instead of triggers be used to fire once for each statement on a view?
Can we use rowid as primary key?
What is a sql profiler?
Explain table and field in sql?
Why select is used in sql?
What is mdb stand for?
Can cursors be part of a trigger body?
Why we use stored procedure instead of query?
How to raise user-defined exception with custom sqlerrm ?
Can we insert data into view?
