用left outer join(sql)实现只显示重复行最小id的记录

SQL> select a.a,b.b from test a left join (select * from test where a in(select min(a) from test group by b)) b on a.a=b.a order by a.a;

  A B
--- ----------
  1 zxy
  2
  3
  4 zxz
  5 zxb

SQL> select * from test;

  A B
--- ----------
  1 zxy
  2 zxy
  3 zxy
  4 zxz
  5 zxb

请使用浏览器的分享功能分享到微信等