作为参考，这称为"groupwise-maximum"

For reference, this is known as "groupwise-maximum"

http://dev. mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html