I am doing queries that produce a table that looks something like this:
Count | IP Address | First Seen | Last Seen | Days
5000 10.0.0.1 2005-12-10 2006-04-15 50*
6500 10.0.0.2 2006-04-01 2006-04-06 3**
*So of the 5000 events "count(*) between 2005-12-10 and 2006-04-14"
the count was distributed within 50 distinct days.
**This time the count is still high and it occured within 3 days
between 2006-04-01 and 2006-04-06.
I just cant figure out how to come up with the days part :).
On 4/23/06, John Hicks <johnlist@stripped> wrote:
> 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?