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

Please explain oracle left join with an example?

960

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1670

List the types of joins used in writing subqueries?

945

How do I start tns listener?

990

What is the use of oracle?

988

What are the predefined tablespaces in a database?

1012

Can you create a synonym without having a table?

984

What is logical backup in oracle?

969

How do we create privileges in oracle?

995

What are the different types of database objects?

995

How to lock and unlock a user account in oracle?

1030

what is reindexing?

1614

What are the extensions used by oracle reports?

998

How many types of table in Oracle?

1067

Explain the difference between sap and oracle?

980