List:General Discussion« Previous MessageNext Message »
From:Ravi Kumar. Date:October 28 2007 2:33am
Subject:Re: Record Counting
View as plain text  
Sorry a correction....

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

Ravi

On 10/28/07, Peter Brawley <peter.brawley@stripped> wrote:
>
> Neil,
>
> Do you mean ...
>
> SELECT DATE(datetimecol) AS date,colourcol,COUNT(*)
> FROM tbl
> GROUP BY date,colourcol;
>
> PB
>
> ------
>
> Neil Tompkins 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
> >
> > ------------------------------------------------------------------------
> >
> > No virus found in this incoming message.
> > Checked by AVG Free Edition.
> > Version: 7.5.503 / Virus Database: 269.15.11/1094 - Release Date:
> 10/26/2007 8:50 AM
> >
>

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