mysql中,这条语句如何写呢

mysql中,这条语句怎么写呢?idleixing1a2b3c4d5a6a每个leixing,我只想要一条记录,并且是id最大哪一条,sql语

mysql中,这条语句怎么写呢?
idleixing
1a
2b
3c
4d
5a
6a
每个leixing,我只想要一条记录,并且是id最大哪一条,sql语句怎么写呢?


[解决办法]
drop table if exists table1;
create table table1(id int(11),leixing char(1),primary key (id));
insert into table1 values(1, 'a '),(2, 'b '),(3, 'c '),(4, 'd '),(5, 'a '),(6, 'a ');
select max(id),leixing from table1 group by leixing

===============

query result(4 records)
max(id) leixing
6 a
2 b
3 c
4 d