Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118134 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 a database? : Sql dba
What are sql ddl commands?
Can we use join in subquery?
What are pl/sql cursor exceptions?
What is meant by temporal data?
What is procedure and function in sql?
what is the syntax for using sql_variant_property? : Transact sql
How to add, remove, modify users using sql?
Can you do multiple joins in sql?
Is it possible to read/write files to-and-from PL/SQL?
Is it possible to link two groups inside a cross products after the cross products group has been created?
How do I view a table in sql?
Is vs as in pl sql?
How many types of normalization are there?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
