Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102590 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 pl sql record in oracle?
What are the types of index in sql?
Why we use triggers in mysql?
What is a .db file?
Explain ddl statements in pl/sql?
what are all the different types of indexes? : Sql dba
explain advantages of myisam over innodb? : Sql dba
what is the difference between nested subquery and correlated subquery?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What are all types of user defined functions?
Do foreign keys improve performance?
how to fetch common records from two tables? : Sql dba
How does postgresql compare to oracle/db2/ms sql server/informix?
Can we use distinct and group by together?
Explain what is a view?
