SELECT salary FROM employee where rownum < 6 ORDER BY salary DESC gro

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

Question Posted / lakshya

Answer Posted / lakshya

SELECT salary FROM employee where rownum < 6 ORDER BY
salary DESC
group by dept;

Is This Answer Correct ?

11 Yes

39 No

Please Help Members By Posting Answers For Below Questions

What are the predefined tablespaces in a database?

1011

Describe varray?

1007

candidate key is subset of super key but not vice-verse explain

2019

What is blob data type in oracle?

1049

What is the difference between a hot backup and a cold backup in oracle?

961

What is set operator oracle?

923

How to start your 10g xe server?

970

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1896

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2434

Can we write dml statement in function in oracle?

1026

How to apply filtering criteria at group level in oracle?

987

What is a procedure in oracle?

1076

Explain what are the advantages of views?

1014

Can we write insert statement in function in oracle?

1027

ABOUT IDENTITY?

2006