SQL Server 2008从表中删除没有唯一列的重复记录 [英] Sql server 2008 Delete duplication record from table which have no unique column

问题描述

我如何从没有唯一列(主键，唯一键)的表中删除重复记录.

How i can delete duplication records from a table which have no unique columns(primary key,Unique key).

推荐答案

，因此您要检查所有或什么...

检查此链接可能会帮助您解决问题....

http://www.simple -talk.com/sql/t-sql-programming/removing-duplicates-from-a-table-in-sql-server/ [

so you want to check all the or what...

Check this link may help your problem....

http://www.simple-talk.com/sql/t-sql-programming/removing-duplicates-from-a-table-in-sql-server/[^]

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