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

5 Answers
9992 Views
Microsoft, Oracle, TCS, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2084

How many file formats are supported to export data?

1266

can u plz provide me oca sql dumps please i need them

1996

What is BBED in Oracle?

1196

Explain the dml?

1044

What is tns name?

1026

What is an oracle transaction?

1228

What are the oracle built-in data types?

1134

what is normalisation?what are its uses?

2328

What is a table index?

1167

What is a subquery?

1191

How to view the tablespaces in the current database?

1025

How to use fetch statement in a loop?

1066

What is oracle data type?

1006

How much memory your 10g xe server is using?

1153