select * from (select e.*,rownum r from (select distinct sal from emp ord

find out the third highest salary?

Question Posted / akshita

Answer Posted / akshita

select * from (select e.*,rownum r from (select distinct
sal from emp order by sal desc) e) where r = 3

Is This Answer Correct ?

43 Yes

16 No

Please Help Members By Posting Answers For Below Questions

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1073

What is the difference between truncate & delete command?

1177

Differentiate between translate and replace?

1109

what is the difference between functional dependecy and multilevel dependency?

2457

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1030

What are the logical operations?

1119

What is Library Cache in Oracle?

1142

How can we force the database to use the user specified rollback segment?

1147

Explain oracle insert into command?

1110

What are the extensions used by oracle reports?

1033

how to do daily transactions with out sql* loader control file regesterd in apps?

1683

how to make an oracle object

2352

How to create a new user account in oracle?

1014

Explain oracle left join with an example?

1005

How to call a sub procedure?

1092