select * from tb A where not exists (select 1 from A.name=name and A.value<value)
假设VALUE唯一 select `name`,max(`values`) from tt group by `name` or select * from tt A where not exists (select 1 from A.`name`=`name` and A.`value`<`value`)
mysql>select name,max(value) from tbl_name group by name;
[征集]分组取最大N条记录方法征集,及散分....
from tb A
where not exists (select 1 from A.name=name and A.value<value)
select `name`,max(`values`) from tt group by `name`
or
select * from tt A
where not exists (select 1 from A.`name`=`name` and A.`value`<`value`)