select max(sal)-5 from emp where dept = 'sale' union all select

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

Question Posted / md valiyullah

Answer Posted / md valiyullah

select max(sal)-5 from emp where dept = 'sale'
union all
select max(sal)-5 from emp where dept = 'purchase'

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is a nested table and how is it different from a normal table?

1114

How many types of table in Oracle?

1177

How to write a left outer join with the where clause in oracle?

1134

What is Java Pool in Oracle?

1253

What is sharded cluster?

1073

What are the types of trigger in oracle?

1032

Is oracle a language?

993

What is data file?

1155

How to assign a tablespace to a users in oracle?

1092

How to retrieve data from an cursor to a record?

1162

What are the attributes that are found in a cursor?

1124

how do u setup a replication site?

2035

What is merge in oracle?

1099

How many types of synonyms in Oracle?

1183

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2876