删除表中的重复记录 [英] Delete duplicate record in a Table

问题描述

我有一个表名"fileupload"，具有4000条记录.有2列("uploadcount"，"createcount")没有主键.

全部重复.
我想删除除第一条记录以外的所有记录/我只想保留一条记录并删除其余记录.

有人可以建议对此进行SQL查询吗?


谢谢大家
问候
Asutosha

I have a Table name "fileupload" having some 4000 records.There are 2 column("uploadcount","createcount") without primary key.

ALL are duplicate.
I want to delete all records except first / I want to keep only one record and delete rest.

can anybody suggest sql query for that ?


Thanks you all
Regards
Asutosha

推荐答案

http://support.microsoft.com/kb/139444 [^ ]
从SQL表中删除重复的记录 [

http://support.microsoft.com/kb/139444[^]
Remove duplicate records from SQL tables[^]

这篇关于删除表中的重复记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！