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 the difference between truncate & delete command?

1186

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?

2827

How to create a server parameter file?

1141

How to resolve name conflicts between variables and columns?

1031

How to connect to a local oracle 10g xe server?

992

How to concatenate two text values in oracle?

1114

What are the built-in functions used for sending Parameters to forms ?

3390

How to create a new oracle data file?

1032

What happens to the indexes if a table is recovered?

993

Explain the characteristics of oracle dba?

1120

How to add a new column to an existing table in oracle?

1141

How to define an oracle sub procedure?

1146

What are the uses of Database Trigger ?

1720

What is a table in oracle?

981

Design database draw er diagram for a certain scenario ?

4579