In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any other transformation than the aggrator? if yes how?
we can use SQ transformation write the query we get ans:
select sun(sal) from emp where deptno=10 and deptno=5;
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!