如表
num score
1 23
1 23
2 60
3 70
2 60
想删成
num score
1 23
2 60
3 70
这样,怎么做啊?
------解决方案--------------------------------------------------------
完全一样?要借助临时表了.
------解决方案--------------------------------------------------------
unload to 'test_kk.unl '
select * from test_kk
group by 1,2
;
delete from test_kk
;
load from 'test_kk.unl '
insert into test_kk
------解决方案--------------------------------------------------------
笨方法：select distinct num from tabname into temp a1
delete from tabname
insert into tabname select * from a1
还有简单的方法，难得去想。。