分组取某项值最大的整条记录

• 表结构

CREATE TABLE `Test` (
`id`  varchar(32) NOT NULL ,
`name`  varchar(64)  ,
`kind`  varchar(64) ,
`value`  int(18) ,
PRIMARY KEY (`id`)
)

• 数据
  
• SQL
  SELECT * FROM Test t1 WHERE not EXISTS(select 1 from Test t2 WHERE t2.value>t1.value and t1.name = t2.name);
• 结果
•