如何在SQL中去重某一列的重复值显示所有的数据

--例如:column_name这一列内容重复，id为主键
select * from table_name where id in (select min(id) from table_name group by column_name)