一、查找数据去掉重复记录 distinct
(1)查询语句数据,进行去重
select distinct * from TableName
(2)删除表重复记录(所有字段重复,记录保留1条) ,使用临时表方式:
select distinct * into #TempTable from TableName
delete table tableName
select * into tableName from #TempTable
drop table #TempTable
一、查找数据去掉重复记录 distinct
(1)查询语句数据,进行去重
select distinct * from TableName
(2)删除表重复记录(所有字段重复,记录保留1条) ,使用临时表方式:
select distinct * into #TempTable from TableName
delete table tableName
select * into tableName from #TempTable
drop table #TempTable