thanks for all the replies. actually i am not able to find the manual
for ROLLUP and GROUPING SETS.
Can anyone tell me where to find it?