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's query optimization and without use of IN AND Exist can we get another way data from query

2139

What are the uses of a database trigger?

994

Explain parameter file in oracle.

1025

Explain the difference between a procedure and a function?

1166

How to invoke the data pump export utility?

1181

Explain what are synonyms used for?

1034

How to use attributes of the implicit cursor in oracle?

1008

What is the maximum limit on the number of columns in a table?

1082

What are the attributes of cursor?

1048

How to convert numbers to characters in oracle?

1029

Oracle

2373

Explain alias?

1135

How to create a new oracle data file?

1030

How to list all indexes in your schema?

1087

How to pass a cursor variable to a procedure?

1105