文件名: 数据库.txt

创建日期: 2025-06-17 12:44:06

delete f
  from ac_payrec_flow f
 inner join (select voucher_no, min_no=min(flow_id)
 from ac_payrec_flow
 group by voucher_no, sheet_amt, paid_amt
having count(1) > 1) b on b.voucher_no=f.voucher_no and b.min_no<>f.flow_id
字数统计: 46