select depid,max(sal) from <table name> group by depid;

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

Question Posted / sunil

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

Answer Posted / sunil

select depid,max(sal) from <table name> group by depid;

Is This Answer Correct ?

33 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to get execution statistics reports on query statements?

1156

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2423

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2345

Explain what are clusters?

1161

What is the difference between I and G in Oracle?

1155

Hi Can any one tell me what are the API's used in requisition import.

1977

what is a Nested Loop join?

2177

what is the difference between substr and instr function in oracle?

1143

What is program global area (pga) in oracle?

1092

What is a data lock in oracle?

1182

How to create an initialization parameter file?

1110

how to join query for one source type is oracle another source type is sql server ?

2479

How would you best determine why your MVIEW couldnt FAST REFRESH?

1935

How do we get field detail of a table?

1132

What are the extensions used by oracle reports?

1092