Average of rows, not columns

[Scorez2000]

This is probably easy as pie, but I don't know
how to do it.

In a database, I have a table with a bunch of
fields. All number fields are numbers. I need to pull an
average for each record of about 8 fields.

I thought the AVG function would do the trick,
but that averages everything in the column. I
need it to average the vale over a few fields for
each record.


Ok, for example, if there was Field1, Field2, Field3 and a record with the values 7, 4 and 10, then the field in the resultant query would have the value 10.

Thanks in advance.

 

[MichaelRed]

thread701-764205




MichaelRed

 

[cmmrfrds]

This type of problem can be handled directly in SQL by temporarily normalizing the data with Unions and making all the Union queries a derived table.

Select temp.id, avg(temp.field1)
From
(
Select id, field1 from yourtable
Union
Select id, field2 from yourtable
Union
Select id, field3 from yourtable
etc....
) as temp