select empno,max(sal) sal,deptno from emp where empno in (select e.empno

i want department wise maxmum salary and empolyee name

Question Posted / satya

9 Answers
29803 Views
I also Faced
E-Mail Answers

Answer Posted / satya

select empno,max(sal) sal,deptno from emp where empno in
(select e.empno from emp e where e.sal=(select max(a.sal) from
emp a where deptno=e.deptno)) group by deptno,empno;

Is This Answer Correct ?

2 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between I and G in Oracle?

1099

interview questions with answer for cts

2583

What do you mean by merge in oracle?

996

What is execute immediate in oracle?

1021

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2498

What is set verify off in oracle?

1106

How many types of tables are there in oracle?

1061

How to use "if" statements on multiple conditions?

1174

What are a collation and state the different types of collation sensitivity?

1171

What are internal user account in oracle?

1009

Explain do view contain data?

1013

What is the difference between 10g OEM and 11g OEM?

965

What is the max number of columns in an oracle table?

1001

What is catalog in Oracle?

1367

Explain compound trigger in oracle?

1040