Hi friends i think it is surely work because i worked for this. select *

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / uday

69 Answers
118521 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

Please Help Members By Posting Answers For Below Questions

How to read xml file in oracle pl sql?

913

What is difference between db2 and sql?

1001

tell us something about heap tables. : Sql dba

1099

What are stored procedures in mysql?

1019

explain access control lists. : Sql dba

1002

What is the file extension for sql database?

1001

Does sql support programming?

1074

What is the difference between the conventional and direct path loader? : aql loader

1153

What is sql profiler in oracle?

1095

Why do we need databases?

1048

how to get help information from the server? : Sql dba

941

Explain about various levels of constraint.

949

what is datawarehouse? : Sql dba

1017

What is the difference between partition and index?

992

what is the difference between truncate and drop statements? : Sql dba

1126