select sal from emp e where 3>=(select count(distinct sal) from emp wh

how to retrieve the top 3 salaries of the table using rownum

Question Posted / nitesh

Answer Posted / nitesh

select sal from emp e where 3>=(select count(distinct sal)
from emp where sal>e.sal) order by sal desc;

Is This Answer Correct ?

5 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to run sql*plus commands in sql developer?

1134

What is an alias command?

1040

what is an index? : Sql dba

978

What are aggregate functions in sql?

1139

Explain alias in sql?

1027

how to check myisam tables for errors? : Sql dba

1305

Enlist the advantages of sql.

986

How do I run a program in pl sql?

989

Is sql better than excel?

1119

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1004

Are subqueries faster than joins?

995

describe mysql connection using mysql binary. : Sql dba

1047

What is pl/sql table? Why it is used?

1024

What is a delimiter in sas?

1035

How to read/write files from pl/sql?

1023