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
9812 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

1) Does oracle have any table which contain all the exceptions and it's code internally?

1761

How to execute a stored program unit?

1087

How to convert numbers to characters in oracle?

1038

Explain oracle data types with examples?

1038

How to delete a user account in oracle?

990

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2228

Give syntax for SQL and ORACLE joins.

1101

What is oracle instant client?

1031

What is a proxy class?

1063

what happened to the global index when I truncate the data in one of the partition?

2030

What are temporal data types in oracle?

1130

Explain an index?

1142

What is recovery manager(rman) backup in Oracle?

1195

How to install oracle database 10g xe?

1029

What suggestions do you have to reduce the network traffic?

974