1. 找出相应Group条件下的重复数据
sql 代码
- select sht_id,timestamp,evt_cate from kabusr.hasheet
- where evt_timestamp > '2007-04-09 07:00:00' and evt_timestamp < '2007-04-10 07:00:00'
- group by sht_id,timestamp,evt_cate
- having count(*)>1