Question

SQL怎么删除一个表中某字段相同的记录，但保留一条

求一个命令：删除news表中title字段相同的记录。但要保留一条不删除。
比如这个title字段有很多都是aaa的记录。只留一条，其余的全部删掉。

Answer 1

delete from news where title not in (select max(title) from news group by title);

Answer 2

存储过程，游标

cur = select * from t order by title
tmp = '';
while cur.next
{
if(tmp = cur.title)
{
tmp=cur.title;
select cur into newtable;
}
}
delete t;
rename newtable t