Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to do this trick ?

Re: How to do this trick ?

From: Tom Verhagen <tverhage_at_aon.nl>
Date: Fri, 15 Oct 1999 10:22:16 +0200
Message-ID: <3806E438.CC0F5968@aon.nl>


Is there no other column such as a timestamp we can use in your table?

Norazman Abu Sahir wrote:

> Hi,
> I have a table with one colum. When I do a select below are the data.
>
> SQL> SELECT MYNUMBER FROM TESTING;
>
> MYNUMBER
> ----------
> 1
> 3
> 5
> 10
>
> What I would like to do is how to display a different betwen a row value
> with a previous row value.
> Something like this:
>
> MYNUMBER DIFF
> ---------- -------
> 1 0
> 3 2
> 5 2
> 10 5
>
> Have any idea?
> TIA
Received on Fri Oct 15 1999 - 03:22:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US