SQL> create table tt(te number,tes varchar2(2));Table createdSQL> insert into tt values(1,'t');1 row insertedSQL> insert into tt values(1,'t');1 row insertedSQL> insert into tt values(1,'t');1 row insertedSQL> insert into tt values(1,'t');1 row insertedSQL> select * from tt
2 / TE TES
---------- ---
1 t
1 t
1 t
1 tSQL>
问:如何删除重复行只保留一行
2 / TE TES
---------- ---
1 t
1 t
1 t
1 tSQL>
问:如何删除重复行只保留一行
SQL> delete tt where rownum<4;3 rows deletedSQL> select * from tt; TE TES
---------- ---
1 tSQL>
真实表里有好多不同的重复行啊
http://www.oradb.net/sql/find0.htm