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
- 31968 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / manjusure@yahoo.co.in
select * from emp e where 5> (select count(max(sal)) from emp
where e.deptno=deptno and sal>e.sal group by sal);
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is recycle bin in Oracle?
What is PL/SQL ?
What is an oracle cursor variable?
Will you be able to store pictures in the database?explain.
What is key preserved table?
How do I call oracle stored procedures that take no parameters?
How to execute a stored program unit?
What are the restrictions on external table columns?
How to use in conditions in oracle?
Is oracle a relational database?
Is it possible to insert comments into sql statements return in the data model editor ?
What is the difference between Delete, Truncate and Drop in Oracle?
How to export data to a csv file?
What is query image?
