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 a function in oracle pl sql?

1098

How do I send sql query results to excel?

1113

What are system versioned tables?

1074

What is user defined functions?

1028

What does where 1/2 mean in sql?

1144

what is self-join? : Sql dba

1240

What are joins in sql?

1108

What is pls integer?

1091

Explain the purpose of %type and %rowtype data types?

975

How do I count duplicates in sql?

1177

What does data normalization mean?

1028

Write a query to find the names of users that begin with "um" in sql?

1045

State some properties of relational databases?

1115

Enlist the data types that can be used in pl/sql?

1111

Can we use pl sql in sql server?

1136