select max(sal)-5 from emp;

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

Question Posted / md valiyullah

Answer Posted / md valiyullah

Is This Answer Correct ?

2 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How to connect to the server with user account: sys?

1017

Explain what are synonyms used for?

1034

Is primary key indexed by default in oracle?

987

Write a syntax for update query in oracle?

1034

How to view existing locks on the database?

1053

What is the difference between Delete, Truncate and Drop in Oracle?

1131

Explain the use of inctype option in exp command.

1034

How to upsert (update or insert into a table)?

999

Is insert autocommit in oracle?

1068

What happens to the data files if a tablespace is dropped?

1059

What is the Tune Query

2291

How to do paging with oracle?

999

How does oracle handle read consistency?

1097

Can a formula column be obtained through a select statement ?

2324

Explain enable novalidate constraint.

1080