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 latest version?

1185

Design database draw er diagram for a certain scenario ?

4670

How to select all columns of all rows from a table in oracle?

1149

How to use values from other tables in update statements using oracle?

1173

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

1164

How to start an oracle instance?

1111

How to put more than 1000 values into an oracle in clause?

1125

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1967