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

22 Answers
32278 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / md valiyullah

select max(sal)-5 from emp;

Is This Answer Correct ?

2 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I connect to oracle database?

1053

What is a snapshot log?

970

What is the disadvantage of User defind function?

2261

What is an oracle user role?

950

How to select some rows from a table in oracle?

1029

List the parts of a database trigger.

1010

Why does Oracle not permit the use of PCTUSED with indexes?

2390

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1998

Explain coalesce function?

1142

What is the usage of synonyms?

1093

Why do we use coalesce function in oracle?

1076

What is oracle rownum?

911

defination of bitmap index

2073

How to use windows user to connect to the server?

958

How to write date and time literals in oracle?

968