明月出青山root

摘要： 按name分组取val最大的值所在行的数据 select a.* from tb a where val = (select max(val) from tb where name = a.name) order by a.name select a.* from tb a where not ex 阅读全文