Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

dbf2mysql parameter, WWWXXXAPC, wwwxxxAPC, How to unsubscrube from dategen spam, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text

Links

XODOX
Impressum

#1: SUM and GROUP

Posted on 2007-12-03 19:44:46 by Brian

Hi


Whats wrong with this statment?

SELECT
FROM `orders` SUM(del) AS TotalPicked
WHERE datepackedtimestamp = '1196640000'
GROUP BY packedby
ORDER BY packedby

I'm trying to end up with a list of a summed up del from each packed by

EG
John 46
Fred 189
Harry 24

Thanks

Brian







------------------------------------------------------------ --------------------
I am using the free version of SPAMfighter for private users.
It has removed 564 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter for free now!

Report this message

#2: Re: SUM and GROUP

Posted on 2007-12-03 20:00:40 by unknown

Post removed (X-No-Archive: yes)

Report this message

#3: Re: SUM and GROUP

Posted on 2007-12-05 02:06:35 by Brian

"Tom" <tom@to.com> wrote in message news:fj1joo021is@drn.newsguy.com...
> On Mon, 03 Dec 2007 18:44:46 GMT, Brian wrote...
>>
>>Hi
>>
>>
>>Whats wrong with this statment?
>>
>>SELECT
>>FROM `orders` SUM(del) AS TotalPicked
>>WHERE datepackedtimestamp = '1196640000'
>>GROUP BY packedby
>>ORDER BY packedby
>>
>>I'm trying to end up with a list of a summed up del from each packed by
>>
>>EG
>>John 46
>>Fred 189
>>Harry 24
>>
>>Thanks
>>
>>Brian
>>
>
> Hi Brian,
>
> I think you need to put the column names and functions in the SELECT part
> of
> your query and the table name(s) in the FROM part. If you are using the
> SUM
> function with the GROUP BY, that should get you the totals for 'del'.
>
> Tom


Not sure what i was thinking the SUM(del) AS TotalPicked should have been
before
the FROM, DOH !!!

Brian



------------------------------------------------------------ --------------------
I am using the free version of SPAMfighter for private users.
It has removed 637 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter for free now!

Report this message