I have a table delivery_history which is populated by a trigger: id(guid)order_numberdelivery_numberhauliertimestamp(getdate())
suppose I have two columns of integers, A and B. Now I want distinct values from these, meaning if both A and B have 1, I want 1 only once.
I have a batch job that I run on a table which I\'m sure 开发者_JS百科I could write as a prepared statement. Currently it\'s all in Java and no doubt less efficient than it could be. For a table like