你看看下面一条删除重复sql语句能否搞 delete from jxk where rowid!=(select max(rowid) from jxk jxk2 where jxk.dhhm=jxk2.dhhm) 注:JXK2为表JXK的别名.DHHM是jxk表中的需要删除的重复字段
MERGE INTO bonuses D USING (SELECT employee_id, salary, department_id FROM employees WHERE department_id = 80) S ON (D.employee_id = S.employee_id) WHEN MATCHED THEN UPDATE SET D.bonus = D.bonus + S.salary*.01 WHEN NOT MATCHED THEN INSERT (D.employee_id, D.bonus) VALUES (S.employee_id, S.salary*0.1);
将所查出来的数据存入一临时表中,通过该临时表和原表对照,并指定一条件来进行删除:)具体的SQL语句自己写吧,因为我不知道你的表结构,只要思路对,就很容易搞定
delete from jxk where rowid!=(select max(rowid) from jxk jxk2 where jxk.dhhm=jxk2.dhhm)
注:JXK2为表JXK的别名.DHHM是jxk表中的需要删除的重复字段
USING (SELECT employee_id, salary, department_id FROM employees
WHERE department_id = 80) S
ON (D.employee_id = S.employee_id)
WHEN MATCHED THEN UPDATE SET D.bonus = D.bonus + S.salary*.01
WHEN NOT MATCHED THEN INSERT (D.employee_id, D.bonus)
VALUES (S.employee_id, S.salary*0.1);