select sal from emp a where 3>(select count(distinct(sal))from emp b wh

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

Question Posted / swapnareddy

Answer Posted / swapnareddy

select sal from emp a where 3>(select
count(distinct(sal))from emp b where a.sal<b.sal);

Is This Answer Correct ?

4 Yes

3 No

Please Help Members By Posting Answers For Below Questions

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

985

How do you create a unique index?

985

What is sqlerrm?

880

what are the different type of sql's statements ? : Sql dba

871

What is the difference between function and procedure in pl/sql?

1013

How subquery works in sql?

992

Why self join is used in sql?

909

What is group by in sql?

1018

What is rank dense_rank and partition in sql?

965

What are the two types of exceptions in pl/sql?

962

What is basic structure of pl sql?

984

How delete all data from table in sql?

947

Does mysql_real_escape_string prevent sql injection?

906

What are the different parts of a package?

1038

What are the dml statements?

1094