Answer / rakesh

select deptno, sum(sal) from emp group by deptno having sum(sal)>(select avg(sum(sal)) from emp group by deptno);

Answer / ravikishore

select deptno,sum(sal) from emp group by deptno having
sum(Sal) =(select max(sum(sal)) from emp group by deptno)

Answer / shankar

select * from emp a where sal>(select avg(sal) from emp b
where a.deptno=b.deptno)

Answer / moorthy g

select deptno, max(sal) from emp group by deptno
having max(sal)> (select avg(max(sal)) from emp group by
deptno);

Output:

DEPTNO MAX(SAL)
---------- ----------
10 5000

Answer / aashish

select department_ID, sum(salary) from emp group by department_ID having sum(salary) > (select avg(sum(salary)) from emp group by department_ID);

Answer / jz

select deptno,max(sal) from emp
group by deptno
having max(sal)>(select avg(sum(sal) )from emp
group by deptno)


:)

Answer / rakesh

select deptno, sum(sal) from emp group by deptno having sum(sal)>(select avg(sum(sal)) from emp

Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,

Separate from an archive server and a powerhouse?

0 Answers  

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

What is the meaning of decode in informatica?

0 Answers  

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.

8 Answers  

Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 Answers  

What is the target load order?

3 Answers   HCL, Informatica,

What is the difference between source qualifier transformations source filter to filter transformation?

0 Answers  

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

What are the different types of schemas?

11 Answers   ITC Infotech,

Which is the best place to learn Informatica Powercenter Online Training?

1 Answers  

What is version control in informatica ? Advance thanks

6 Answers   HCL, Puma,