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

Why does oracle 9i treat an empty string as null?

1055

What is pragma autonomous transaction in oracle?

1068

Define oracle database

1043

How to see free space of each tablespace?

1034

How remove data files before opening a database?

1072

6. Display the client name and order date for all orders using the traditional method.

2305

When system tablespace is created?

1041

How to create a new view in oracle?

1078

what is the difference between restoring and recovering?

1011

How to load data from external tables to regular tables?

1062

How do we represent comments in oracle?

1048

What is the database name in oracle?

1021

Explain what are synonyms used for?

1034

Why does Oracle not permit the use of PCTUSED with indexes?

2424

How to do clean up if create database failed?

1027