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

What is oracle update statement with inner join ?

998

How do you store pictures in a database?

955

What is control file used for?

1105

How to retrieve the count of updated rows?

1060

What is SQL access advisor in Oracle?

1141

How to turn on or off recycle bin for the instance?

1015

what is difference between sql plus and sql*plus? (not sql and sql plus).

3822

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2294

What is a dead lock in oracle?

1050

what is IDE,DMV in sql server?

2758

Where do we use decode and case statements?

945

How to execute the package in oracle?

1039

How to store pictures on to the database?

926

How can we view last record added to a table?

974

Explain how are indexes update?

1018