Hi all,
I am under Oacle 10G R1
I can use PL/sql sql
How can I compare 2 consecutive rows in a table
and show the result, I want to check the value > 0
this is the list
A1 110
A2 112
A3 112.3
A4 112.4
A5 112.5
A11 113
A12 113.2
A21 114
A23 106
A31 118
A33 120
A34 122
A35 123
A36 124
A37 124.1
I want to do
A1-A2
A2-A3
...
Ai-1 -Ai
and I cannot determine in advance that I will have the number of rows
Thanks
I am under Oacle 10G R1
I can use PL/sql sql
How can I compare 2 consecutive rows in a table
and show the result, I want to check the value > 0
this is the list
A1 110
A2 112
A3 112.3
A4 112.4
A5 112.5
A11 113
A12 113.2
A21 114
A23 106
A31 118
A33 120
A34 122
A35 123
A36 124
A37 124.1
I want to do
A1-A2
A2-A3
...
Ai-1 -Ai
and I cannot determine in advance that I will have the number of rows
Thanks