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

5 Answers
9622 Views
Microsoft, Oracle, TCS, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the benefits of ordbms?

1050

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1063

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5366

How to experiment a data lock in oracle?

1016

Give the various rollback segment states.

1012

What is the difference between alert log file and tarce file ?

2120

How to sort the query output in oracle?

980

What is the difference between I and G in Oracle?

1045

What are advantages of dateset in datastage?

2217

Explain oracle’s server parameter file.

963

what is the scripts in data base?

2099

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

970

Explain the use of ignore option in imp command.

992

How to change program global area (pga) in oracle?

1047

How to upsert (update or insert into a table)?

970