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 <[EMAIL PROTECTED]> 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 > > >
