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

what is reindexing?

1616

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

2252

What are the original export and import utilities?

1066

How do you bind variables in oracle?

934

How do we create privileges in oracle?

995

What is the difference between Delete, Truncate and Drop in Oracle?

1074

Explain the use of inctype option in exp command.

982

What is a sub query? What are its various types?

1089

What is the disadvantage of User defind function?

2246

How to write a left outer join with the where clause in oracle?

1032

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2000

How to define an anonymous procedure without variables?

1029

Can we protect our pl/sql source code?

994

What is a table index in oracle?

1076

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1016