List:General Discussion« Previous MessageNext Message »
From:Neil Tompkins Date:October 27 2007 9:22am
Subject:Record Counting
View as plain text  
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