<div>
SELECT SUM(viewnum) from your table,,,<br />
<br />
but this will give u an outpot only for the sum...so if u want to display sum in front of all the columns then this wont work...<br />
so u will have to write 2 different queries and then combine the results
</div>


SELECT SUM(viewnum) from your table,,,

but this will give u an outpot only for the sum...so if u want to display sum in front of all the columns then this wont work...
so u will have to write 2 different queries and then combine the results

<div>
<div class="content wysiwyg-content">
Here's my sql statement so far<br />
<br />
SELECT DISTINCT email, fromemail, viewnum from TABLE<br />
<br />
I want an SQL statement that will add the numbers in the field viewnum.<br />
<br />
Here's a sample output<br />
<br />
email &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fromemail &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; viewnum<br />
john@here.com &nbsp; &nbsp;bob@there.com &nbsp; &nbsp; &nbsp;34<br />
this@that.com &nbsp; &nbsp; &nbsp; that@this.com &nbsp; &nbsp; &nbsp; &nbsp;4<br />
<br />
so basically i want the statement to give me 38.<br />
<br />
Thanks, hope this was clear.
</div>
</div>


Here's my sql statement so far

SELECT DISTINCT email, fromemail, viewnum from TABLE

I want an SQL statement that will add the numbers in the field viewnum.

Here's a sample output

email                     fromemail                 viewnum
john@here.com    bob@there.com      34
this@that.com       that@this.com        4

so basically i want the statement to give me 38.

Thanks, hope this was clear.

Add numbers in a field in MySQL

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.