sql中如何删除一个表中重复的记录?

Question

create table a_dist(id int,name varchar(20))

insert into a_dist values(1,'abc')
insert into a_dist values(1,'abc')
insert into a_dist values(1,'abc')
insert into a_dist values(1,'abc')

删除重复记录，sql语句该怎么写?

Answer 1

还是跟着热心网友混生活吧。