How to do this trick ?

From: Norazman Abu Sahir <norazman_at_ti.com>
Date: Fri, 15 Oct 1999 11:15:05 +0800
Message-ID: <38069C38.A089334E_at_ti.com>

Hi,
[Quoted] [Quoted] 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 - 05:15:05 CEST