查询A表中name重复的记录:
SELECT a.*, a. ROWID FROM a WHERE a.ROWID>(SELECT MIN(ROWID) FROM a a1 WHERE a.name=a1.name )
删除对于记录:
delete from a WHERE a.ROWID>(SELECT MIN(ROWID) FROM a a1 WHERE a.name=a1.name )
查询A表中name重复的记录:
SELECT a.*, a. ROWID FROM a WHERE a.ROWID>(SELECT MIN(ROWID) FROM a a1 WHERE a.name=a1.name )
删除对于记录:
delete from a WHERE a.ROWID>(SELECT MIN(ROWID) FROM a a1 WHERE a.name=a1.name )