select * from tab_name where id in (
select min(id) from tab_name group by meter_id,Cjq_time having count(*)>1)
delete from tab_name where id in(
select id from (
(select a.id from tab_name a ,
(select meter_id,Cjq_time,min(id) id,count(*) icount from tab_name group by meter_id,Cjq_time having count(*)>1) b
where a.meter_id=b.meter_id and a.cjq_time=b.cjq_time and a.id>b.id )
)c
)