title: Multiply Values from Col1 to Number of Columns in SQL
body: <p>If I have a dataset in SQL like this: </p>
  
  <pre><code>ColA    ColB    ColC     ColD     ColE
     4       8       9        1       10
  </code></pre>
  
  <p>How do I multiply each column value together but by indexing rather then typing out the column names such as: </p>
  
  <pre><code>1:number_of_columns(dataset)
  Multiply all values together
  </code></pre>
  
  <p>The reason I want to index this is because the number of columns will not always be the same length and indexing this dataset would solve this problem in a dynamic fashion. </p>
  
  <p>Final Output: </p>
  
  <pre><code>ColA    ColB    ColC     ColD     ColE      Total
     4       8       9        1       10      2,880
  </code></pre>
  
  <p>This final code though should be able to solve a dataset even like this: </p>
  
  <pre><code>ColE    ColG    ColD     
     45     33      44 
  </code></pre>
  
  <p>Result: </p>
  
  <pre><code>ColE    ColG    ColD       Total  
     45     33      44      65,340
  </code></pre>