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 are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

975

Can procedure in package be overloaded?

1030

How are sql commands classified?

1038

How can you fetch first 5 characters of the string?

948

How do you delete a table?

1001

What are the two types of exceptions in pl/sql?

969

List the various privileges that a user can grant to another user?

990

How to use distinct and count in sql query? Explain

961

Can we connect to postgresql using sql developer?

937

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

994

What company owns postgresql?

963

What are the limitations of sql express?

988

How many columns should be in an index?

904

What are primary key and foreign key and how they work?

929

what are properties of a transaction? : Sql dba

1018