qsc xcv

qsc xcv

  • NA
  • 2
  • 2.5k

a table value is unpivot

Mar 12 2013 6:24 AM
i have a table socitymain which has some value like..................

id  | socityname |  house |  population |  areaofsocity
1   |  abcd      |  10    |   150       |     10
2   |  cdf       |  5     |     15      |     20  
3   |  zxc       | 20     |   20        |     10   
4   |  bnm       | 98     |  10         |    30
.         .                   .            .                     .
.         .                   .            .                    .
n        n                 n           n                    n


i want reslut sum of socityid,sum of hpuse,sumof population in range of areawise like this..............
 values     |  0to10 |   11to20 |  21to30  |  31up
 socity     |   2    |     1    |    1     |   
 house      |   30   |    5     |   98     |
 population |   170  |     15   |    10    |