mysql 分组按name分组取值最大一条,不理解啊,求解惑。
select a.* from test a where 1 > (select count(*) from test where name = a.name and val > a.val ) sql语句,按name分组显示最大的v...
select a.* from test a where 1 > (select count(*) from test where name = a.name and val > a.val ) sql语句,按name分组显示最大的v...