percy


{ City } hydrabad
< Country > india
* Profession * developer
User No # 71673
Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 1
Users Marked my Answers as Wrong # 2
Questions / { percy }
Questions Answers Category Views Company eMail




Answers / { percy }

Question { 6931 }

my soure table is emp having columns sal,deptno in the
deptno 10,20,30deptno row are there expected out
put is min(sal) of 10th deptno,max(sal) of 20th
deptno,mean(sal) of 30th deptno using aggregation stage


Answer

use aggregator stage in that perform first keycolumn as 10
and give calculation for sal as min sal
next take as 20 as key column maxsal for calculation same
as 30th dept

Is This Answer Correct ?    1 Yes 2 No