Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102944 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / tejasvita dhuri
select id,salary from (select id,salary,ROW_NUMBER()over (order by salary desc) as rowcol from emp)A
where A.rowcol=2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is synonyms?
Can we rollback delete command?
Do foreign keys improve performance?
How do I start pl sql?
How do I run a query in pl sql developer?
What is Collation Sensitivity ? What are the various type ?
what are the limitations of identity column? : Transact sql
What is integrity in sql?
What is percent sign in sql?
What is a function in oracle pl sql?
Why is theta join required?
Why commit is not used in triggers?
Can we enter data in a table in design view?
How do you truncate?
What is materialized view. What are different methods of refresh?
