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
- 32274 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
How to write a query with a left outer join in oracle?
What is the difference between sharding and replication?
What are the restrictions on external table columns?
how do u setup a replication site?
How to invoke the original export import utilities?
What are transaction isolation levels supported by oracle?
What is oracle server autotrace in oracle?
Can you assign multiple query result rows to a variable?
How a tablespace is related to data files?
Explain a segment?
Are truncate and delete commands same? If so why?
How to declare a local variable?
Can group functions be used in the order by clause in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What do you mean by group by clause?
