Does anyone know how calculate the total value of all the results of a selected field.
This is a discussion on Does anyone know how calculate the total value of all the results of a selected field. within the MySQL Database forums, part of the Database Forums category; Hi Does anyone know how calculate the total value of the results of a selected field....
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
12-14-2006
|
|||
|
|||
Re: Does anyone know how calculate the total value of all the results of a selected field.
moishyyehuda@gmail.com wrote: > Hi > > Does anyone know how calculate the total value of the results of a > selected field from a mysql database. 
|
|
12-14-2006
|
|||
|
|||
|
Re: Does anyone know how calculate the total value of all the results of a selected field.
moishyyehuda@gmail.com wrote: > moishyyehuda@gmail.com wrote: > > Hi > > > > Does anyone know how calculate the total value of the results of a > > selected field from a mysql database. er... SUM?
|
|
12-14-2006
|
|||
|
|||
|
Re: Does anyone know how calculate the total value of all the results of a selected field.
strawberry wrote: > moishyyehuda@gmail.com wrote: > > > moishyyehuda@gmail.com wrote: > > > Hi > > > > > > Does anyone know how calculate the total value of the results of a > > > selected field from a mysql database. > > er... SUM? sum total my mistake as in john made three payments $1.00 $3.00 $ 2.00 sum total is $6.00
|
|
12-14-2006
|
|||
|
|||
|
Re: Does anyone know how calculate the total value of all the results of a selected field.
moishyyehuda@gmail.com wrote: > strawberry wrote: > > moishyyehuda@gmail.com wrote: > > > > > moishyyehuda@gmail.com wrote: > > > > Hi > > > > > > > > Does anyone know how calculate the total value of the results of a > > > > selected field from a mysql database. > > > > er... SUM? > sum total my mistake as in john made three payments $1.00 $3.00 $ 2.00 > sum total is $6.00 SELECT SUM(payments) AS total FROM table WHERE name = 'John';
|
Linear Mode
