mysql order by group by

select * from myclass;

 

 select id from myclass group by name order by degree desc limit 1;

 

 select * from myclass where id = (select id from myclass group by name order by degree desc limit 1);

 

 但是写成

select * from myclass where id in (select id from myclass group by name order by degree desc limit 2);

的时候会报错。

提示当前mysql版本不支持这种语法