qsc xcv

qsc xcv

  • NA
  • 2
  • 2.4k

a table value unpivot and sum of those values

Mar 20 2013 1:37 AM
i have a table socitymain .it's some row given here..........
here i display few row for example but really data is more than 1000 row...
--------------------------------------------------------------------
id socityname house population  areaofsocity
1 abcd 10 150 10
2 cdf 5 15 20
3 zxc 20 20 10
4 bnmc  98 10 30






i want result the area's range wise socity count,population sum ,house sum

like......
values 0to10 11to20 21to30 31up



socity 2 1 1




house 30 5 98




population 170 15 10