select * from emp a where &n=(select count(b.sal) from emp b where b.

find out the third highest salary?

Question Posted / hanumantha r challa

Answer Posted / hanumantha r challa

select * from emp a where &n=(select count(b.sal) from emp
b where b.sal>=a.sal);

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain rename?

1046

Give the constructs of a package, function or a procedure.

1098

How to drop a stored procedure in oracle?

1106

How to write a left outer join with the where clause in oracle?

1132

What is the difference between sharding and replication?

1138

State the difference between a primary key and foreign key?

998

How to use in conditions in oracle?

1116

How to invoke the original export import utilities?

1135

Difference between open_form and call_form in oracle.

1224

Write a syntax for update query in oracle?

1076

What exactly do quotation marks around the table name do?

1027

How to export data with a field delimiter?

1088

How to save query output to a local file?

1087

How to connect asp pages to oracle servers?

1121

How to define default values for formal parameters?

1096