select e.department_id,max(e.salary) from employees e group by e.departme

I have one table :EID,Depid,ename,sal
I want to have max(sal) in each department.

Question Posted / omar

Answer Posted / omar

select e.department_id,max(e.salary)
from employees e
group by e.department_id
order by e.department_id desc;

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

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

965

What is the best way to do multi-row insert in oracle?

1038

How can Oracle users be audited?

1078

What is the difference between substr and instr?

1007

What is procedure overloading in oracle?

1018

How to rename an index in oracle?

1087

What are the uses of Database Trigger ?

1664

Which is better Oracle or MS SQL? Why?

6314

What are the attributes of the cursor?

959

interview questions with answer for cts

2556

What is the difference between substr & instr functions?

1175

How to count groups returned with the group by clause in oracle?

1034

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2926

Use of an integrity constraint is better to validate data. Explain

1005

Which are the five query types available in oracle?

924