Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118568 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / deven
select top 1 salary from emp where salary <>(
select top 1 salary from emp order by salary desc) order by
salary desc
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is a table partition?
What are inner and outer joins examples of both?
How can you load microsoft excel data into oracle? : aql loader
How exception is different from error?
How can I change database name in sql?
Should I use mbr or gpt?
Explain two easy sql optimizations.
What is dml statement?
What are the set operators in sql?
What is difference between cursor and trigger?
what is the difference between truncate and drop statements? : Sql dba
explain the difference between delete , truncate and drop commands? : Sql dba
Do we need commit after truncate?
Why do we use sqlite?
What kind of join is join?
