select a.sal from (select distinct(sal) from emp order by sal desc)a where

Find out the 3rd highest salary?

Question Posted / xyz

Answer Posted / xyz

select a.sal from (select distinct(sal) from emp order by
sal desc)a where rownum=3

Is This Answer Correct ?

2 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Can delete statement be rollbacked?

954

What is the difference between union and union all command?

1032

what is data integrity? : Sql dba

1007

What programs use sql?

958

What is an escape character in sql?

1001

what is online transaction processing (oltp)? : Sql dba

957

What company owns postgresql?

982

What is schema in sql?

908

what is a tablespace? : Sql dba

1018

How to select unique records from a table?

1018

Can we write ddl statements in functions?

1073

What is break?

1159

What are the properties of a transaction?

1094

What are the two types of exceptions.

1125

Explain ddl statements in pl/sql?

979