Re: Count rows group by time intervals

At 8:07a -0400 on 09 May 2007, Loredana Curugiu wrote:
> I have the following table:
>
> theme |   receiver        |           date
> ---------+----------------------+------------------------
>  LIA   | +40741775622 |  2007-04-27 00:00:00+00
>  LIA   | +40741775622 |  2007-04-25 00:00:00+00
>  MIA   | +40741775622 | 2007-04-27 00:00:00+00
>  MIA   | +40741775622 |  2007-05-09 00:00:00+00
>
> I would like to count rows group by theme, receiver, and time  
> intervals of
> two days. I don't know how to start.

Should get you started:

SELECT
	COUNT( * ),
	theme,
	receiver,
	date
FROM
	yourTable
GROUP BY
	theme,
	receiver,
	date
;

Kevin