转载自：http://www.geeklab.info/2012/11/mysql-how-to-get-top-n-rows-for-each-group/

We have the following table and data:

 
CREATE TEMPORARY TABLE girls(

name text,

haircolor text,

score INT

);

INSERT INTO girls VALUES ('M[......]

继续阅读