Interested to Buy Any Domain ? << Click Here >> for more details...
how will I find the first 5 highest salaried employees in
each dept in oracle.
- 22 Answers
- 31979 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / mihir nasikkar
select *
from employee X
where salary in (select top 5 salary
from employee
where dept = X.dept
order by salary desc)
order by dept, salary desc
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What are the parameters that we can pass through a stored procedure?
How can we create the complete backup of data in the oracle.
what is the difference between restoring and recovering?
What is enter substitution variable in oracle?
How to convert numbers to characters in oracle?
what is dynamic SGA and static SGA
What do you understand by database schema and what does it hold?
How do I find my oracle client driver version?
What is an oracle transaction?
How to generate query output in html format?
what are archived logs?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What are oracle functions?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
