select  name,
        dw,
        s1,
        xs,
        th
from   (select  name,
                dw,
                s1,
                xs,
                th
        from    yourtable
        union all
        select  name   '小計' as name,
                dw as dw,
                null as s1,
                sum(xs) as xs,
                sum(th) as th
        from    yourtable
        group by name,dw)
order by
        name,dw