delete from @t where id not in(select id from(select address,min(id) id from @t group by address) t2) 把@t改成你的表名 这句可以实现,不过用的是最笨的办法