avg problem
542673Aug 9 2007 — edited Aug 9 2007Hi,
My table description : x_dummy
Name Null? Type
----------------------------------------------------- -------- -------------
SN1 NUMBER(22,5)
SN2 NUMBER(22,5)
SN3 NUMBER(22,5)
SN4 NUMBER(22,5)
SN5 NUMBER(22,5)
My table data : x_dummy
SN1 SN2 SN3 SN4 SN5
---------- ---------- ---------- ---------- ----------
1 2 3 4
2 3 4
3 4
4
My requirement is to get avg of four columns sn1,sn2,sn3,sn4 into the sn5 column.
sn5 column is null for all rows.
Thanks