select * from (select ename,eno,dept,sal,row_number() over (partition by d

how will I find the first 5 highest salaried employees in
each dept in oracle.

Question Posted / karthik

Answer Posted / karthik

select * from (select ename,eno,dept,sal,row_number() over
(partition by dept order by sal desc)top5 from emp) where
top5 <= 5

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is columnar storage what is the advantage?

986

What is the difference between sharding and partitioning?

931

Explain the use of record length option in exp command.

1026

How can we delete duplicate rows in a table?

929

How to pass parameters to procedures?

975

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5333

What is index-organized table in Oracle?

1021

What is meant by recursive hints in oracle?

1029

Explain about functional dependency and its relation with table design?

954

What is an oracle table?

934

What are the advantages of oracle?

963

How many types of auditing in Oracle?

983

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1591

What is a proxy class?

969

How to define a procedure inside another procedure?

964