select
a.name,a.re
from
表 a
where
not exists(select 1 from 表 where name=a.name and id>a.id)
select
a.name,a.re
from
表 a,
(select name,max(id) id from 表 group by name) b
where
a.name=b.name and a.id=b.id
a.name,a.re
from
表 a
where
not exists(select 1 from 表 where name=a.name and id>a.id)
select
a.name,a.re
from
表 a,
(select name,max(id) id from 表 group by name) b
where
a.name=b.name and a.id=b.id
(select name,max(id) maxid from table group by name) temp,table
where table.name = temp.name and table.id = temp.maxid
select a.name,a.re from(select * from table where id in (select max(id) from table group by name) a;
from tb a join
(
select name,max(id) maxid
from tb
group by name
) b
on (a.name=b.name and a.id=b.maxid)