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