重复数据只取一条

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

编程技巧