List:General Discussion« Previous MessageNext Message »
From:Ravi Kumar. Date:October 27 2007 10:53am
Subject:Re: Record Counting
View as plain text  
Hi Neil,

Try this:

SELECT LEFT(DATE_FIELD_NAME, 10), COLOR_FIELD_NAME, COUNT(T.*) AS CNT FROM
TABLE_NAME GROUP BY LEFT(DATE_FIELD_NAME, 10), COLOR_FIELD_NAME.

Post the table structure if this does not help.

Regards,

Ravi

On 10/27/07, Neil Tompkins <neildtompkins@stripped> wrote:
>
> Hi,
>
> I have a table of records all of which have a timestamp against them like
> 2007-10-25 10:10:19, and category like red, blue etc and a unique key.
>
> Using a SELECT statement is it possible to retrieve the count and number
> of records for each day e.g 2007-10-25 for all red, and all blue etc
>
> Thanks.
> Neil
> _________________________________________________________________
> Feel like a local wherever you go.
> http://www.backofmyhand.com

Thread
Record CountingNeil Tompkins27 Oct
  • Re: Record CountingRavi Kumar.27 Oct
  • Re: Record CountingPeter Brawley27 Oct
    • Re: Record CountingRavi Kumar.28 Oct
      • Re: Record Countingranjeet walunj30 Oct