求一个SQL查询语句

Question

有一个表dpxstz
spbh            spmc        lsj         xssl   
030100569018    030100569   28          12
030100569028    030100569   28          12
030100569048    030100569   15          5
030100670018    030100670   25          7
030100670028    030100670   12          4
030100670038    030100670   25          4
要求得到
spmc        lsj       xssl
030100569   28        24
030100569   15        5
030100670   25        11
030100670   12        4

Answer 1

select  spmc ,lsj ,       xssl  =sum(xssl  ) from dpxstz group by  spmc ,lsj

Answer 2

select  spmc ,lsj ,       xssl  =sum(xssl  ) from dpxstz group by  spmc ,lsj

Answer 3

select  spmc ,lsj , xssl  =sum(xssl) from dpxstz group by  spmc ,lsj