SQL queries each student's highest score MySQL statement

Zhang San Chinese 100 Zhang three mathematics 83 Li four languages 88 John Doe Mathematics 100 queries each student's highest achievement. Select b.* from (select Name,max (score) score from course GROUP by name) a LEFT JOIN course B on a. ' Name ' =b. ' Name ' and A.S Core=b.score; The feeling is a bit less rigorous, but the results of the query is right. If non-MySQL executes above, the quotation marks of the field are removed.

SQL queries each student's highest score MySQL statement