查找表中某几个字段重复的记录

查找表中某几个字段重复的记录

 

select rowid,ledger_id,bid from fb_ledgers  t1 where t1.rowid!=(select max(rowid) from fb_ledgers  t2 where t1.bid=t2.bid  and t1.ledger_type=t2.ledger_type  and  t1.act_date=t2.act_date  and  t1.dir_flag=t2.dir_flag);