select * from emp_test where sal IN(select max(sal) from emp

I have one table :EID,Depid,ename,sal
I want to have max(sal) in each department.

Question Posted / venkat

Answer Posted / venkat

select * from emp_test where sal IN(select max(sal) from
emp_test group by deptno)

Is This Answer Correct ?

1 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is connection pooling in oracle?

976

What are the major difference between truncate and delete?

1063

How to view all columns in an existing table?

937

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1945

Explain the use of rows option in exp command.

1095

What do you mean by a tablespace?

1042

Is there an oracle sql query that aggregates multiple rows into one row?

987

What are the uses of synonyms?

1138

How to create id with auto_increment on oracle?

991

Explain what does a control file contain?

1105

What is a cognitive schema?

978

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2188

List out the components of logical database structure of oracle database.

1040

How to connect ms access to oracle servers?

1012

What are the types of trigger in oracle?

985