how to retrieve the top 3 salaries of the table using rownum
- 31 Answers
- 36984 Views
- Oracle, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
How do I save a stored procedure?
What are all the common sql functions?
What is indexes?
Can we call a function containing dml statements in a select query?
Why do we use joins?
What are the rules to be applied to nulls whilst doing comparisons?
How do you write an index?
How do you write a subquery?
what happens if you no create privilege in a database? : Sql dba
How do I order columns in sql?
How we can update the view?
What is use of trigger?
how to calculate the difference between two dates? : Sql dba
What is pivot in sql?
Does pdo prevent sql injection?
