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

How to delete multiple rows from a table in oracle?

1005

How to commit the current transaction in oracle?

1047

What is oracle rownum?

888

How to filter out duplications in the returning rows using oracle?

989

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2433

Explain drop constraint oracle?

991

What is oracle database client?

976

What is a snapshot in oracle database?

974

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1291

What are the roles of dba?

1020

How does Oracle guarantee data integrity of data changes?

2333

What to do if the startbd.bat failed to start the xe instance?

1017

Explain alias?

1080

How to define a data source name (dsn) in odbc manager?

968

What is a database schema in oracle?

1055