sql query advise

aGVsbG8sCmkgaGF2ZSB0aGlzIFNRTCBjb2RlIGluIGEgcHl0aG9uIHByb2dy YW1tZSBidXQgaSB3
YW50ZWQgdG8gY2hhbmdlIHRoZQpTUUwgc28gdGhhdCBpdCByZXR1cm5zIHRv dGFscyBmb3IgZWFj
aCBkYXRlLiBvciBkbyBpIGhhdmUgdG8gbWFrZSBhCmxvb3AgZm9yIGVhY2gg ZGF0ZSByYW5nZSBz
byB0aGF0IGkgZ2V0IHRoZSBmb2xsb3dpbmcgcmVzdWx0cyB3aGljaAp0aGVu IGkgd291bGQgbGlr
ZSB0byBwbG90IG9uIGEgZ3JhcGguCgokIHB5dGhvbiBkYWlseV90b3RhbHMu cHkKKDJMLCBEZWNp
bWFsKCcxNzMuOTU4MzQ0JyksIERlY2ltYWwoJzE1OS45NjYzNDknKSkgMjAx MS0wNi0yMwooNkws
IERlY2ltYWwoJzYyMy44NTgyMDAnKSwgRGVjaW1hbCgnNTgxLjg4MjIxNCcp KSAyMDExLTA2LTIy
Ci4uLgoKaGVyZSBpcyB0aGUgY29kZTogaHR0cDovL3Bhc3RpZS5vcmcvMjEx MTIyNgoKdGhhbmtz
Cgpub3JtYW4KCi0tIArLmcqHxLEgyblvyZ8gxoN1xLHKjsmQZCDHncm5LG5v yo4gyo1vdSBwdcmQ
IMedyZTEsW/JpcmUIMmQIMqeb2/KhyDEsSDKh8mQyaXKhyBzxLEgJ8qHbG7J lMSxyZ/Jn8SxcCBz
xLEgyofJkMmlyo0Ky5l1yo1vcCDHnXDEsXNkbiBwLHXJuW7KhyBw15/JuW/K jSDHncmlyocgx53H
nXMgbm/KjiAnyod1x53Jr8mQ158gc8edya/EscqHIMedyaXKhyBwdcmQICfK h3XHncqHdW/JlArH
nXEgcyzKh8ed158gyofHncqOCiU+Pj4gIiIuam9pbiggWyB7JyonOidAJywn Xic6Jy4nfS5nZXQo
YyxOb25lKSBvcgpjaHIoOTcrKG9yZChjKS04MyklMjYpIGZvciBjIGluICIs YWR5bSwqKSZ1enFe
enFmIiBdICkK

Re: sql query advise

Have a look at GROUP BY and aggregate functions: http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.ht ml

----- Original Message -----
> From: "Norman Khine"
> To: mysql@lists.mysql.com
> Sent: Thursday, 23 June, 2011 4:05:35 PM
> Subject: sql query advise
>
> hello,
> i have this SQL code in a python programme but i wanted to change the
> SQL so that it returns totals for each date. or do i have to make a
> loop for each date range so that i get the following results which
> then i would like to plot on a graph.
>
> $ python daily_totals.py
> (2L, Decimal('173.958344'), Decimal('159.966349')) 2011-06-23
> (6L, Decimal('623.858200'), Decimal('581.882214')) 2011-06-22
> ...
>
> here is the code: http://pastie.org/2111226
>
> thanks
>
> norman
>

--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org