select * from (select distinct sal from emp order by sal desc) where r

find out the third highest salary?

Question Posted / swaminathan

Answer Posted / swaminathan

select *
from (select distinct sal from emp order by sal desc)
where rownum <= 3

Is This Answer Correct ?

9 Yes

13 No

Please Help Members By Posting Answers For Below Questions

How to set up autotrace for a user account?

1112

Please explain drop constraint oracle?

1160

How to do clean up if create database failed?

1071

What are the ways tablespaces can be managed and how do they differ?

2450

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2442

Explain constraining triggers.

1167

What is save point in oracle database?

1366

How to rename a column in an existing table?

1085

What happens to the current transaction if the session is ended?

1137

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1161

What is the difference between 10g OEM and 11g OEM?

1017

List the parts of a database trigger.

1109

Describe the types of sub query?

1058

Explain an exception and its types?

1141

How to best split csv strings in oracle 9i?

1099