Database Systems - (Query) I have duplicate invoices and I need to combine the customer balances. How do I write the equation?
1
Expert's answer
2017-11-18T12:33:06-0500
There is a code, which delete duplicate invoices and combine all clear invoices :
delete test_outer.* from test as test_outer where exists( select * from test as test_inner where test_inner.invoice = test_outer.invoice group by invoice having count(*) > 1 and min(test_inner.id) <> test_outer.id );
Numbers and figures are an essential part of our world, necessary for almost everything we do every day. As important…
APPROVED BY CLIENTS
"assignmentexpert.com" is professional group of people in Math subjects! They did assignments in very high level of mathematical modelling in the best quality. Thanks a lot
Comments
Leave a comment