delete from rainfall a
where (a.d, a.h, a.n) in (select d, h, n from rainfall GROUP BY d, h, n having count(*) > 1) where (a.d, a.h, a.n) in
delete from rainfall a
where (a.d, a.h, a.n) in (select d, h, n from rainfall GROUP BY d, h, n having count(*) > 1) where (a.d, a.h, a.n) in