select max(*) from user where (select * from user group by class); 转载于:https://www.cnblogs.com/kingfly/archive/2013/03/07/2947421.html