name |credit
_____________________
jacky |300
jacky |100
rose |32
jacky |200
rose |500
如何才能查询到这样的结果:
name |total_credit
_____________________
jacky |600
rose |532
...全文
713打赏收藏
求一个查询语句
下面有表数据: name |credit _____________________ jacky |300 jacky |100 rose |32 jacky |200 rose |500 如何才能查询到这样的结果: name |total_credit _____________________ jacky |600 rose |532