mysql-count the top 10 points of all members and

User requirements:

The ranking of the members is ranked according to the top 10 points of the highest points.

Actual situation:

1. The total points rule for the current member is the sum of points in the last 1 years;

2. Integral Detail Table A, Presence field staff ID (personalmember_id) and Integral (Competitionscore_point)

Plan implementation:

Group Personalmember and competitionscore_point of Table A and go to the top 10 of the highest points

Implementation method:

Select s.personalmember_id, sum (s.competitionscore_point) from A swhere 10> (SELECT COUNT (*) from at where T.personalme MBER_ID=S.PERSONALMEMBER_ID and T.competitionscore_point>s.competitionscore_point) GROUP by PersonalMember_ Idorder by s.personalmember_id, S.competitionscore_point desc;

mysql-count the top 10 points of all members and