title: SQL - AVG() on * fields
body: <p>I want to average all values on a table with many fields.</p>
  
  <p>My data looks like this</p>
  
  <pre><code>col1  col2  col3  ...  col100
  ----  ----  ----       ------
  1     1     1          1
  2     4     8          16
  3     9     27         81
  </code></pre>
  
  <p>And to output all the AVG() values in a query, like so:</p>
  
  <pre><code>col1  col2  col3  ... col100
  ----  ----  ----       ------
  2     4.67  12        32.67
  </code></pre>
  
  <p>The following query gives an error.</p>
  
  <pre><code>SELECT AVG(*) FROM table
  </code></pre>
  
  <p>Is there any SQL code to AVG() all fields without explicitly naming them?</p>
  
  <p>Note: Using OpenOffice Base.</p>