List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:October 27 2007 7:07pm
Subject:Re: Record Counting
View as plain text  
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