select e.ename,e.sal from emp e where 3>(select count (distinct(b.sal))

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

Question Posted / kalyan kumar

Answer Posted / kalyan kumar

select e.ename,e.sal from emp e where 3>(select count
(distinct(b.sal)) from emp b where b.sal>e.sal)

Is This Answer Correct ?

19 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What is the difference between microsoft sql and mysql?

951

What is rowtype?

999

What are the different parts of a package?

1100

What does data normalization mean?

942

explain the delete statements in sql

1028

Can we delete column in sql?

1078

What are different types of triggers?

1085

How can I change database name in sql?

1051

What does select count (*) mean in sql?

1005

Does inner join return duplicate rows?

962

How we can update the view?

1039

How do I run a pl sql procedure in sql developer?

953

what happens if null values are involved in expressions? : Sql dba

1029

Is primary key a clustered index?

959

What is normalisation in sql?

1041