Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102926 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / babbu
it's easy with self join:
select max(sal) from emp e1,emp e2 where e1.sal < e2.sal
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
What is oracle and pl sql?
Explain how can you save or place your msg in a table?
What is multiple columns?
How to call a javascript function from pl sql?
What is record type in pl sql?
how to start mysql server? : Sql dba
Differentiate between pl/sql and sql?
Is a foreign key always unique?
what is sp_pkeys? : Transact sql
What is sqlcontext?
What does t sql mean?
What is trigger in pl sql?
Explain sql data types?
How can you select unique records from a table?
What are the basic techniques of indexing?
