Obtain the mysql Query summary statement ~

Obtain the mysql Query summary statement ~ The table structure is as follows:

Id uid scroe ------------- 1 1 1.52 1 1.83 2-5.54 3 0.85 2 8.26 1-27 4 38 2 2.3 --------------

Uid is the user id. now you need to query and calculate the total score of each user, which is displayed under the user, that is, the front-end displays similar to this:

User score ------------ 1 1.51 1.81-21 summary 1.32-5.52 8.22 summary 2.32 5.03 summary 0.83 34 Summary 3

Reply to discussion (solution)

Http://sqlfiddle.com /#! 2/8446d2/11

Http://sqlfiddle.com /#! 2/8446d2/11
++

Http://sqlfiddle.com /#! 2/8446d2/11