how will I find the first 5 highest salaried employees in
each dept in oracle.
Answer Posted / jas
select a.sal,a.emp_no from employee a
where 5=(select distinct(count(*) from
employee b where a.sal> b.sal)
| Is This Answer Correct ? | 8 Yes | 9 No |
Post New Answer View All Answers
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
Please explain joins in oracle?
How to use in conditions in oracle?
What are the original export and import utilities?
Explain an exception and its types?
Why use resource manager in Oracle?
What is the dynamic sql in oracle?
What is snapshot is too old? Give and example for better understand.
Name the various constraints used in oracle?
Design database draw er diagram for a certain scenario ?
What is an oracle data file?
What do you mean by cdb and pdb in oracle 12c?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What is the usage of synonyms?
How to convert characters to dates in oracle?