查询重复项
select * from "JJYX"."USERVALUE4" a where
(a.USERMETERID,a.COLLECTTIME)
in(select USERMETERID,COLLECTTIME from "JJYX"."USERVALUE4" group by USERMETERID,COLLECTTIME having count(*) > 1)
删除重复项
delete from "JJYX"."USERVALUE4" a
where (a.USERMETERID,a.COLLECTTIME)
in
(select USERMETERID,COLLECTTIME from "JJYX"."USERVALUE4" group by USERMETERID,COLLECTTIME having count(*) > 1)
and rowid not in (select min(rowid) from "JJYX"."USERVALUE4" group by USERMETERID,COLLECTTIME having count(*)>1)