So if you have got the following data:
Code:
order_no part_no qty
1 1 20
1 1 18
what should be the correct output - two rows or one row; in case of one row, what would be the criteria for selecting the quantity e.g. random, lowest, highest, other?
Best Regards