Integrate row information with previous rows sql : Hi I need to integrate row information with previous rows
---------------------------------------------
|      ID      |   no| number |
-----------------------------------------
|       1      |   40|   10   |
|       2      |   32|   12   |
|       3      |   40|   15   |
|       4      |   45|   23   |
|       5      |   32|   15   |
|       6      |   12|   14
|       7      |   40|   20
|       8      |   32|   18
|       9      |   45|   27
|       10     |   12|   16
------------------------------

result 

---------------------------------------------
|      ID      |   no| number |last number
-----------------------------------------
|       1      |   40|   10   |0
|       3      |   32|   12   |0
|       3      |   40|   15   |0
|       4      |   45|   23   |0
|       5      |   32|   15   |12
|       6      |   12|   14   |0
|       7      |   40|   20   |15
|       8      |   32|   18   |15
|       9      |   45|   27   |23
|       10     |   12|   16   |14
------------------------------

thanks for your help..