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

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

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

?

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);