Delete d duplicate既record

delete from accountsubledgertransaction

where transactionid in(

select min(transactionid) as transactionid from AccountSubledgerTransaction

where type='inv'

group by DocRefId

having count(*)>1

)