二、實現方法： 1、查詢重復記錄 select rowid,haptime,numberplate,reason from peccancy --delete from peccancy6 peccancy6 where peccancy.rowid != ( select max(rowid) from peccancy b where peccancy.haptime = b.haptime and peccancy.numberplate = b.numberplate and peccancy.reason = b.reason )
2、刪除重復記錄 delete from peccancy peccancy where peccancy.rowid != ( select max(rowid) from peccancy b where peccancy.haptime = b.haptime and peccancy.numberplate = b.numberplate and peccancy.reason = b.reason )
