Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102619 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
Why indexing is needed?
Is sql harder than python?
What is trigger and types?
What is a ddl command?
how can we find the number of rows in a table using mysql? : Sql dba
What can you do with pl sql?
What is group function in sql?
Does a user_objects view have an entry for a trigger?
What is the use of sqlerrd 3?
What does plv msg allows you to do?
What is meant by user defined function?
how to analyze tables with 'mysqlcheck'? : Sql dba
Can pl sql procedure have a return statement?
What is the difference between rollback and rollback to statements?
What is the life of an sql statement?
