On Nov 19, 6:24 pm, myk <[EMAIL PROTECTED]> wrote:
> 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
On my way out the door but what you should do is take a peek at the
documentation for the LAG function at
http://download.oracle.com/docs/cd/B10501_01/server.920/a96540/functions56a.htm#SQLRF00652
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
