Paul Halliday wrote:
> I am trying to formulate a query that will increment if a condition is true.
> For example, if I do a select (just let me know if there was data on
> this day, if so increment count by 1 and check the next day) where
> timestamp between jan and feb.
Could you be a bit more specific?
Where do you want to store the count?
What do you mean by "if there was data on this day"? Does the design of
the table anticipate no more than one record per day? Does each record
correspond to a single day?