select * from T_BE_TransDetail where
(FBIZTIME,FBANKACCOUNTID,FOPPBANKNUMBER,FTRANSBALANCE,FCREATETIME )
in (SELECT FBIZTIME,FBANKACCOUNTID,FOPPBANKNUMBER,FTRANSBALANCE,FCREATETIME
FROM T_BE_TransDetail
where FBIZTIME >= trunc(sysdate - 1)
and FBIZTIME < trunc(sysdate)
GROUP BY FBIZTIME,FBANKACCOUNTID,FOPPBANKNUMBER,FTRANSBALANCE,FCREATETIME
having count(*)> 1)
ORDER BY FBIZDATE ASC,FCREDITAMOUNT ASC
--根据每天交易明细,选择字段:交易日期、付方账号、收方账号、发生额,业务时间 这个五个字段时间一样的时候,则初步判定明细重复(时间区间T-1)。
检查数据库表重复数据,检查数据库表:
select * from A表 a where a.id group by a.id having count(*)>1