id name val
1 a 56
2 b 40
3 a 78
4 b 60
......查找出a,b,..最高分所对应的记录如id name val
3 a 78
4 b 60
......select * from user group by name order by val desc 不能找到最高分对应记录（注意输出id）请问要怎么写这条语句
-----------------------------------------------------
CREATE TABLE IF NOT EXISTS `user` (
`id` tinyint(2) NOT NULL,
`name` varchar(10) NOT NULL,
`val` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `user` (`id`, `name`, `val`) VALUES
(1, 'a', 56),
(2, 'b', 40),
(3, 'a', 78),
(4, 'b', 60);
最佳答案
