I have the following table:

Object Id
Item code
Item date
Amount

Does anybody have a script that will eliminate offsetting amounts for
the same item code and date and just produce duplicates?

For example:

1 10 04/28/06 +10.00
2 10 04/28/06 -10.00
3 10 04/28/06 +10.00
4 10 04/28/06 +10.00

Only want to see the last two entries.

Thanks for your help.

Chris



This message (including any attachments) is confidential and intended solely for the use of the individual or entity to whom it is addressed, and is protected by law. If you are not the intended recipient, please delete the message (including any attachments) and notify the originator that you received the message in error. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Vanguard Health Systems.

Oracle LazyDBA home page