How to get the difference of two row values of the same table?

[#1]

Hi all,

i need some help..

table1:

value

23

34

56

67

i need the output to be in follwing manner.

output:

value     variation

23             11
34             22

56             12

68             68

[alexandros17]

this is my example

[#3 · Accepted solution]

Hi

I think it's better to do it in the script. See attached file.

[ankurakash]

Hi Saugat,

The above function will do the needful.

Please check Henric blog post: The Above Function

Regards,

Ankur