陳占的開發社區
只要相信這是對的。。。它永遠不會錯。。。
Showing posts with label
duplicate
.
Show all posts
Showing posts with label
duplicate
.
Show all posts
Tuesday, August 31, 2010
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
)
Older Posts
Home
Subscribe to:
Posts (Atom)