用下面的语句吧:Select 名字,count(*) from rable group by 名字 Having count(*)<2
去查询分析器里试一下吧,我试过,没问题。删除同一表中所有相同项大于等于2的记录。/*Tab 表名 Name 名字 */ delete from Tab where exists(select Name,count(*) from Tab group by Name Having count(*) <> 1 )
这种情况还是用select distinct name from talbe 比较符合
去查询分析器里试一下吧,我试过,没问题。删除同一表中所有相同项大于等于2的记录。/*Tab 表名 Name 名字 */ delete from Tab where exists(select Name,count(*) from Tab group by Name Having count(*) <> 1 )
http://community.csdn.net/Expert/topic/3621/3621461.xml?temp=.2833826
这10000个人里面有可能有两个李四,我现在想把出现两次的李四全删掉,一个都不留。
group by 名字
Having count(*)<2
delete from Tab where exists(select Name,count(*) from Tab group by Name Having count(*) <> 1 )
delete from Tab where exists(select Name,count(*) from Tab group by Name Having count(*) <> 1 )