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

How to write a left outer join with the where clause in oracle?

1163

Design database draw er diagram for a certain scenario ?

4670

How to start an oracle instance?

1111

How to put more than 1000 values into an oracle in clause?

1124

How to select all columns of all rows from a table in oracle?

1148

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1967

What is oracle latest version?

1184

How to use values from other tables in update statements using oracle?

1173