How to do this trick ?

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 Thu Oct 14 1999 - 22:14:45 CDT