重复数据只取一条

程序员文章站 2024-04-05 20:25:48

...

无详细内容无 select * from Table1 where ID in (select min(ID) from Table1 group by DuplicateColumn)

select * from Table1 where ID in (select min(ID) from Table1 group by DuplicateColumn)

推荐阅读

mysql查找删除重复数据并只保留一条实例详解