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 to check the server version in oracle?

1035

What is SQL access advisor in Oracle?

1137

How many types of auditing in Oracle?

983

Define oracle database

993

What are the roles of dba?

1021

How to create a temporary table in oracle?

1194

What is oracle open database communication (odbc)?

962

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

1058

What is a tns service name?

944

What are a collation and state the different types of collation sensitivity?

1095

What is literal?

956

How to insert a record into a table?

1022

What happens to the current transaction if a ddl statement is executed?

952

what is the difference between restoring and recovering?

965

How to download oracle database 10g xe?

960