Re: Fw: Count rows group by time intervals

 

You need a query that returns the number of receivers on each theme, in two days intervals, is this correct?

Please try something like this. I am not sure if it works, because I don't have a table like yours.

I am assuming  your  table is called table

 

SELECT  a."date",a."theme",a.receiver,COUNT(*)
FROM table a
INNER JOIN table b
ON a."theme" = b."theme" AND a.receiver = b.receiver
WHERE (((b."date" - a."date") = 1) OR (b."date" - a."date") = 0)
GROUP BY a."date",a."theme",a.receiver
HAVING (a."date" - '2007-01-01' ) % 2 = 0
ORDER BY a."date"