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

How to convert times to characters in oracle?

1027

What is the maximum limit on the number of columns in a table?

1089

What are dml statements in oracle?

1096

How to load a large xml file?

1059

What is the difference between $oracle_base and $oracle_home?

1091

What is bulk copy or bcp in oracle?

1126

What is user managed backup in Oracle?

1148

What is the usage of save points in oracle database?

965

How do I uninstall oracle 11g?

1124

How to change system global area (sga) in oracle?

1014

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1025

How to write a query with an inner join in oracle?

1044

Explain how you would restore a database using RMAN to Point in Time?

2149

How to insert multiple rows with one insert statement in oracle?

1093

What is transaction control statement and how many types of transaction control statement in Oracle?

1163