oracle中: select a,but from (select a,but row_number over(partition by a order by b) entry from t) where entry = 1
mysql中: select a,substring_index(group_concat(b order by but asc), ‘,’ ,1) as but from (select a,b from t) order by a
(mysql是把这一组数据分组,按逗号拼接起来,取第一个数据;oracle的原理一样)