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

Can we connect to ORACLE db using Windows Authentication?

722

How can I create database in oracle?

569

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

1855

What is oracle in java?

524

What is merge in oracle?

561

What is a system tablespace?

600

Can we create database in oracle using command line ?

584

What is sharded cluster?

520

How to convert raw data type into text in oracle? Explain

603

What are the execution control statements?

621

Explain the features of oracle?

598

Explain the difference between sap and oracle?

575

Explain a segment?

619

What are the varoius components of physical database structure of oracle database?

567

How to insert multiple rows with one insert statement in oracle?

570