22,199
社区成员
发帖
与我相关
我的任务
分享
--如果只有ID,NAME两个字段,则如下:
select min(id) id , name from a group by name
--如果不止这两个字段,则如下:
select t.* from a t where id = (select min(id) from a where name = t.name)
select t.* from a t where exists (select 1 from a where name = t.name and id < t.id)
select min(id) id,name from A group by name