Dear all,

Could anyone tell me whether loops can be programmed in SQL. And if so, is there any information available on the net? (I've been looking for a while now, but only found tutorials)

I am used to program languages like Matlab, R, C++ and S-Plus. And I was wondering how one programs something like the following in SQL:

For i=2 to N do ;
B[i-1,1] = A[i,1] - A[i-1,1] ;
end ;
...