建立一个临时表
select distinct(A,B,C...) into temptable from table
然后删掉原表记录
delete from table
然后把临时表记录在导回
select * into table from temptable
select distinct(A,B,C...) into temptable from table
然后删掉原表记录
delete from table
然后把临时表记录在导回
select * into table from temptable
应作以下修改:Create procedure update_table_A
as
SELECT id = max(id),A,B,C into Temp_table from TABLE_A group by a,b,c
DELETE FROM TABLE_A
INSERT INTO TABLE_A(ID,A,B,C) SELECT * FROM Temp_table
drop table Temp_table。。 sql = "exec update_table_A"
cm.execute(sql) 'cm -> commond
同意楼上!
DELETE FROM TABLE WHERE ID NOT IN (
SELECT MAX(ID)
FROM TABLE
GROUP BY A,B,C);不用临时表
偷学楼上的
呵呵
DELETE FROM TABLE WHERE ROUND(ID/2,0)=(ID/2)