0
Answer

a table value unpivot and sum of those values

Ask a question
qsc xcv

qsc xcv

11y
1k
1
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