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

Answer Posted / sunil

Is This Answer Correct ?

33 Yes

4 No

Please Help Members By Posting Answers For Below Questions

candidate key is subset of super key but not vice-verse explain

2045

What is analyze command used for?

1028

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1002

What do you mean by a database transaction & what all tcl statements are available in oracle?

953

How different is ms access and oracle?

999

How to assign a table row to a record variable?

990

What is BBED in Oracle?

1115

WHAT IS ecc 6.0

2119

What is an Oracle Instance?

1092

What do you mean by group by clause?

1009

How to update values in a table in oracle?

981

What is Undo Management Advisor in Oracle?

1062

How to fetch the row which has the max value for a column?

968

What are a cluster and non-cluster index?

983

How many categories of data types in oracle?

993