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

Can I create table without primary key?

940

what are all different types of collation sensitivity? : Sql dba

932

What is Histogram?

1506

how to convert dates to character strings? : Sql dba

1073

What are the different types of dbms?

956

Is sql scripting language?

975

Is trigger a stored procedure?

887

What are the types of optimization?

889

What are the different types of joins in sql?

1659

What is a field in a database?

1006

What is a primary key sql?

992

what is cross join? : Sql dba

941

What is rollback?

1038

what is schema? : Sql dba

987

What are the main features of cursor?

1041