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 happens if the update subquery returns multiple rows?

1072

what is normalisation?what are its uses?

2232

What is the use of aggregate functions in oracle?

993

What is the data type of dual table?

950

How to pass parameters to procedures?

999

What is oracle in java?

934

What are the components of logical database structure in oracle database?

1057

How can we find out the duplicate values in an oracle table?

1017

What is a user role in oracle?

1086

What is an oracle user role?

956

What is a procedure in oracle?

1116

How can I create database in oracle?

977

What is the quickest way to fetch the data from a table?

1019

Can we connect to ORACLE db using Windows Authentication?

1210

what is the difference between functional dependecy and multilevel dependency?

2434