how to retrieve the top 3 salaries of the table using rownum
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
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
What is a temporal data type?
How do you add a column to a table?
How many joins can you have in sql?
How do I quit sql?
What does the file extension accdb stand for?
What is the difference between function, procedure and package in pl/sql?
What are functions in sql?
Is keyword pl sql?
What are the differences between in and exists clause?
How do I trace sql profiler?
What is sql in java?
Why do we use function in pl sql?
What is string join?
What is on delete restrict?