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 the oracle implicit cursor?

596

What is key preserved table?

567

Explain oracle’s server parameter file.

566

How to see the table columns used in an index?

596

How to define a cusotmer as a supplier in ORACLE R12

1728

What is the difference between formal parameters and actual parameters?

547

What are the arithmetic operations?

588

How many categories of data types in oracle?

605

What is a database table in oracle?

572

What is format trigger?

1616

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2395

Is the After report trigger fired if the report execution fails ?

2404

Does oracle database need java?

523

How many types of cluster table in Oracle?

579

What is a user role in oracle?

613