Hello,

I have a Problem:

The folowing Data are in a table:
1|10
2|30
3|50
4|100
5|20
6|10
7|60
8|50
9|40
10|10

I need a SQL to get this output:

20
75
15
55
25

--> adding 2 Datas and calculate the middle (AVG)

Is there any way to solve this problem.
I want not solve this problem with an Script.

Sorry for my bad english ;-))


Thx

Andreas