DELETE FROM gen_schoolspace a
WHERE ROWID >
(SELECT MIN (ROWID)
FROM gen_schoolspace b
WHERE a.address = b.address
AND a.DRIVESCHOOLBOSNUM = b.DRIVESCHOOLBOSNUM);
WHERE ROWID >
(SELECT MIN (ROWID)
FROM gen_schoolspace b
WHERE a.address = b.address
AND a.DRIVESCHOOLBOSNUM = b.DRIVESCHOOLBOSNUM);