查询不重复数据
SELECT * FROM jnbus_zzfc_mx j WHERE j.ROWID IN (SELECT MAX(ROWID) FROM jnbus_zzfc_mx t GROUP BY t.driverid,leavetime)
删除重复数据
DELETE FROM jnbus_zzfc_mx j WHERE j.ROWID NOT IN (SELECT MAX(ROWID) FROM jnbus_zzfc_mx t GROUP BY t.driverid,leavetime)