SQL删除重复数据

name.age.是重复的，sql:

 

Delete   from  TB  where  id  not   in  ( 
select   max (t1.id)  from  TB t1  group   by  t1.id, 
t1.name,t1.age)

 

 

转载于:https://www.cnblogs.com/Zoya/archive/2010/03/03/1677156.html