基于oracle的数据去重处理

基于Oracle中的去重处理
有表test如下：

cola	colb
aa	bb
aa	bbbbb
aa	bb
aa	bb

• 获取表中的cola，colb列去重后的结果有以下几种方式：

1. select distinct cola,colb from test;
2. select unique cola,colb from test;
3. select cola,colb from test group by cola,colb;
4. select cola,colb from test union select cola,colb from test where 1=2;

• 删除cola,colb重复的数据只保留一条，删除后test表中的数据如下：

cola	colb
aa	bb
aa	bbbbb

1. delete from test where test in（select min(rowid) from test group by cola,colb）;
2. delete from test where test in（select max(rowid) from test group by cola,colb）;