AVG (in SQL) question

I have a table where I have twenty columns numbers. Now, I would like to count average for each of these columns. Do I really have to write a select avg(column_name) etc... for each column sepatarely, or is there easier way??? Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.

justerman@my-deja.com wrote: > > I have a table where I have twenty columns numbers. Now, I would like to > count average for each of these columns. Do I really have to write a > select avg(column_name) etc... for each column sepatarely, or is there > easier way??? My but we are lazy. No there is no easier way to do this, sorry. Art S. Kagel