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 are the two virtual tables available at the time of database trigger execution?

1155

What is prepared statement in sql?

992

Mention what are different methods to trace the pl/sql code?

1096

How many triggers can be applied to a table?

992

Why do you partition data?

962

What are types of exception?

873

Can we call procedure in select statement?

969

Enlist the characteristics of pl/sql?

1734

What is %type in pl sql?

920

Can we join 3 tables in sql?

954

What is the clause we need to add in function body to return variable?

965

What does where 1/2 mean in sql?

1006

can a stored procedure call itself or recursive stored procedure? : Sql dba

955

What is nosql vs sql?

1118

how many triggers are allowed in mysql table? : Sql dba

994