SQL request
From: D'Aletto Tony <daletto_at_tchad.cad.cea.fr>
Date: Wed, 1 Dec 1993 09:20:26 GMT
Message-ID: <1993Dec1.092026.17929_at_nenuphar.saclay.cea.fr>
Date: Wed, 1 Dec 1993 09:20:26 GMT
Message-ID: <1993Dec1.092026.17929_at_nenuphar.saclay.cea.fr>
here is my table T1 ( row_number integer(2)
distance number
temp number)
between 1 to 11 here are the rows in the table :
1 d1 t1
2 d2 t2
3 d3 t3
...
11 d11 t11
i would like to get via sqlplus/PL.SQL
temps(i) versius (d(i)+ d(i+1))/2
e.i. (d1+d2)/2 t1
(d2+d3)/2 t2 ...
and i can't !
I will be interested in any solutions ...
thanks
Tony
you can reply by mail
daletto_at_tchad.cad.cea.fr
Received on Wed Dec 01 1993 - 10:20:26 CET