一个简单的sql问题？

[flamefiredelphi]

一个表中有很多重复的数据，把重复的删除掉，仅仅保留一个!
例如 A B C
1 2 3
1 2 3
1 2 3
2 3 4
2 3 4
得到：A B C
1 2 3
2 3 4

[jpabcd]

select distinct a,b,c from table

[LGQDUCKY]

不显示相同记录，例如只要A，B，C字段相同就显示第一条记录
select distinct a,b,c from table_name

[jiezhi]

delete from table_name where rowid not in
(select rowid from (select distinct a,b,c from table_name))

[lilygy5]

DELETE FROM TABLE_NAME
WHERE ROWID!=(SELECT MAX(ROWID) FROM TABLE_NAME D
WHERE TABLE_NAME.COL1=D.COL1 AND TABLE_NAME.COL2=D.COL2);

[wupangzi]

delete from t t where t.rowid !=

(select max(rowid) from t tt where t.c1=tt.c1 and t.c2=tt.c2);

[David1289]

jiezhi(浪子) 的语句比较简单明了

[beckhambobo]

http://www.oradb.net/sql/find0.htm

[bluemeteor]

delete from TA a where a.rowid!=(select max(rowid) from TA b where a.bm=b.bm and a.mc=b.mc);