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

What is the size of partition table?

989

explain advantages of myisam over innodb? : Sql dba

1014

How does sql*loader handles newline characters in a record? : aql loader

984

What is the difference between between and in condition operators?

939

What is a recursive stored procedure?

1095

what is a cursor? : Sql dba

972

What is package in pl sql?

961

How do I run sql?

1092

what is the different between now() and current_date()? : Sql dba

933

Is hadoop a nosql?

948

How do I kill a query in postgresql?

1011

What is a table partition?

1036

How can you tell the difference between an index and a view?

869

Why do we use subquery?

942

what is a database lock ? : Sql dba

1092