怎么删除表中重复记录？？？

[songfengerer]

用sql语句，怎么删除数据表中重复记录，相同记录只留下一条呢？？

[day_dayup]

select distinct * from yourtable

distinct 关键字

[lynx1111]

也许搜索“重复记录”会对你又帮助！

[victorycyz]

select distinctrow * into new_table from table_name

truncate table table_name

insert into table_name select * from new_table

drop table new_table

[eason2000]

delete from 表名 where 主键 in (selecr 主键,count(*) from 表名 group by 主键 having count(*)>1)

[dofly]

這樣的貼子很多﹐搜索一下省點銀子. ^-^
上面已經有答案了。