The grouping is done on from and toloc and one group is been indicated by usrid
Table :
from toloc usrid
a b 1
c d 1 --- group 1
e f 1
-------------------
a b 2
c d 2 --- group 2
e f 2
----------------------
a b 3
c d 3 --- group 3
h k 3
after group set query required resulset ???
from toloc usrid
a b 1
c d 1 --- group 1 & 3 combined to form 1 group
e f 1
-------------------
a b 2![alt text][1]
c d 2 --- group 2
h k 2
How can i achieve the resultset. I have to group similar set of records in sql . Is it possible to do with rollup or the new grouping sets. I m not been able to figure it.
Please refer to link fro the diagram http://www.freeimagehosting.net/image.php?6ab3dc67ab.png
alt text