怎么删除sql表里重复的数据

可以使用SQL语句 "DELETE FROM table_name WHERE column_name IN (SELECT column_name FROM table_name GROUP BY column_name HAVING COUNT(*) > 1)" 来删除重复数据。

其中：
table_name为表名
column_name为需要删除重复数据的列名

该语句会删除表中column_name列的重复数据。

例如:
DELETE FROM student WHERE id IN (SELECT id FROM student GROUP BY id HAVING COUNT(*) > 1)

这条语句会删除 student表中id列的重复数据。