select sal from (SELECT distinct sal FROM emp order by sal desc) where r

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

Question Posted / uttam

Answer Posted / uttam

select sal from (SELECT distinct sal FROM emp order by sal
desc)
where rownum <6

Is This Answer Correct ?

13 Yes

15 No

Please Help Members By Posting Answers For Below Questions

How to insert a record into a table?

1124

How to run the anonymous block again?

1177

Can multiple cursors being opened at the same time?

1119

What are transaction isolation levels supported by oracle?

1119

What privilege is needed for a user to create views in oracle?

1096

State and explain about oracle instance?

1053

How to connect the oracle server as sysdba?

1134

What privilege is needed for a user to delete rows from tables in another schema?

1140

What is bulk collect in oracle?

1059

How to assign data of the deleted row to variables?

1120

What is the difference between pre-select and pre-query?

1305

How can Oracle users be audited?

1172

How to add another datafile to a tablespace?

1095

What is the database name in oracle?

1082

List out the types of joins.

1243