select e.eid,e.sal,e.depid,e.ename,e.sal from emp e where 1>(select c

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

Question Posted / narasimha

Answer Posted / narasimha

select e.eid,e.sal,e.depid,e.ename,e.sal from emp e
where 1>(select count(*) from emp w where e.sal<w.sal and
e.depid=w.depid) order by e.deptno asc

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Why do we use bulk collect in oracle?

1108

Is oracle an operator?

986

Why we use bulk collect in oracle?

1118

How to get a create statement for an existing table?

1017

Explain a synonym?

1089

Point out the difference between user tables and data dictionary?

1038

What is an oracle wallet?

993

What are the advantages of oracle 12c?

1237

How to create an oracle database?

1104

Can select statements be used on views in oracle?

1085

Explain what are the uses of rollback segment?

1068

What is instant client oracle?

1074

11. Display the client number and name and the client number and name of the person who referred that client.

2391

Where is the export dump file located?

1224

How to store only time; not date and time?

1070