select bianhao,xueyuan,id from jiaoyuanclass where id in (select max(id) from jiaoyuanclass group by xueyuan) order by id desc

在读取  表：person  字段：zcishu 中的值，，，，是以  xueyuan 的值来传到给 相等 表person中字段zcishu中

select * from table1,table2 where table2.id in (
select max(id) from table2 group by name) and table1.name
=table2.name;

select * from person,jiaoyuanclass where jiaoyuanclass.id in(select max(id) from jiaoyuanclass group by xueyuan) and person.name=jiaoyuanclass.xueyuan