Hello, I have a table that contains two columns, USER and VALUE. For each user there are multiple values. What I would like to do is, after ordering the list by user and then value, subtract each value from the next value and place this new data-element into a third column named DIFF.
Example: DATA AS IS: USER VALUE 1 7 1 9 1 11 1 13 2 5 2 6 2 7 DATA AS I WOULD LIKE TO GET IT: USER VALUE DIFF 1 7 - 1 9 2 1 11 2 1 15 4 2 5 - 2 8 3 2 15 7 Anyone know how to do this in SQL or PL*SQL? TIA! myk --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
