您可以获取最佳的attrib1值，然后加入attrib2值，并为每个attrib1值获取最佳值：
select t2.catID, t2.attrib1, max(t2.attrib2)from( select catID, max(attrib1) as attrib1 from test_table group by catID) t1inner join test_table t2 on t2.catID = t1.catID and t2.attrib1 = t1.attrib1group by t2.catID, t2.attrib1
