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 a common use of group by in sql?

1097

Do prepared statements prevent sql injection?

1000

Is grant a ddl statement?

945

Explain constraints in sql?

1088

What is a full join?

1044

What is primary key and foreign key?

1014

What is the command used to fetch first 5 characters of the string?

1467

Explain raise_application_error.

1145

Is sql considered coding?

1089

What are the most important characteristics of pl/sql?

1229

How sql query is executed?

1188

What is varchar data type in sql?

1140

Does truncate release storage space?

1137

What do you understand by exception handling in pl/sql?

1089

Which operator is used in query for pattern matching?

1133