Thanks a lot CJ. That's the cost of flexibility:-)
- Original Message -
From: Christian High
To: YL
Cc: mysql@lists.mysql.com
Sent: Sunday, April 22, 2007 12:45 PM
Subject: Re: Grouping Question
On 4/22/07, YL <[EMAIL PROTECTED]> wrote:
I have a co
On 4/22/07, Christian High <[EMAIL PROTECTED]> wrote:
On 4/22/07, YL <[EMAIL PROTECTED]> wrote:
>
> I have a contact table looks like
>
> id type owner_idowner_type value
> 11email21 person [EMAIL PROTECTED]
> 12phone 21
On 4/22/07, YL <[EMAIL PROTECTED]> wrote:
I have a contact table looks like
id type owner_idowner_type value
11email21 person [EMAIL PROTECTED]
12phone 21 person 303-777-
13PO Box18
Bob:
In case if you don't know this just want you to know...
Out of all the messages that I received, I only read your and saved it for the future.
thank you..
seng
-
Before posting, please check:
http://www.mysql.com/m
>I have a GROUPing question on the following query:
>
>SELECT HOUR(closedtime) AS hour, COUNT(assignedto) AS count FROM db WHERE
>(closedtime >='2001-01-01' AND closedtime <= '2001-01-31 23:59:59') AND
>assignedto='person' GROUP BY hour;
>
>give something like this:
>
>+--++---