Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102345 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / uday
Hi friends i think it is surely work because i worked for this.
select * from emp e where 1=(select count(distinct d.esal)
from emp d where d.esal>e.esal)
any one plz try if it's not work
plz let me know.
uday_testing@yahoo.co.in
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
what is the difference between a web-garden and a web-farm? : Sql dba
What is the difference between rollback and rollback to statements?
Mention what does the hierarchical profiler does?
What is the mutating table and constraining table?
Which is better join or inner query?
what is sql server agent? : Sql dba
How to move files from one directory to another in pl sql?
Does sql*plus have a pl/sql engine?
What are the different operators available in sql?
What's the procedure?
How to execute a stored procedure?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What is sql query optimization?
Difference between table function and pipelined function?
what is a join? : Sql dba
