Select * from emp where emp.salary in (select emp.salary from emp

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

Question Posted / ram

Answer Posted / ram

Select * from emp
where emp.salary in (select emp.salary from emp
where (select distict salary
from emp order by desc null last)
where rownum <=3);

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

what is difference between delete and truncate commands? : Sql dba

1105

How is sql used in oracle?

994

How many sql databases can you have on one server?

1061

How can we implement rollback or commit statement in a trigger?

1017

Can sql developer connect to db2?

1013

How delete a row in sql?

974

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1151

How do I clear the screen in sql plus?

1029

what is 'mysqlimport'? : Sql dba

1019

what are all the different types of indexes? : Sql dba

1035

What is the difference between clustered and non-clustered indexes?

1074

i have some prob lem to tell me about my self in interview first round ...

2151

Can you do multiple joins in sql?

1022

How do I save a sql query?

1001

What are the different tcl commands in sql?

1152