Sql Query For Subgroup and Total of Subgroup
select created_by,convert(varchar(10),request_dt,120) as request_dt, timetaken=sum(convert(decimal(5,2),isnull(timetaken,0))),GROUPING([created_by]) AS 'CreatedAgg' ,GROUPING([request_dt]) AS 'ReqdtAgg'from t_crm_requestwhere request_dt >='2012-07-01' and request_dt <='2012-07-10' and callplaced=1group by created_by, request_dt WITH ROLLUP
No comments:
Post a Comment