Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118564 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 the difference between cross join and natural join?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
How do I find duplicates in two columns?
What are the different ways to optimize a sql query?
how to use case expression? : Sql dba
how to select first 5 records from a table? : Sql dba
How do I edit a stored procedure?
How do I find duplicates in the same column?
What is the difference between partitioning and sharding?
Can there be more than one function with a similar name in a pl/sql block?
What is exit statement?
What does 0 mean in sql?
How delete a row in sql?
Can we use views in stored procedure?
How many parts of a pl sql block are optional?
