On Wed, Jun 2, 2010 at 10:55 AM, Oliveiros <oliveiros.crist...@marktest.pt> wrote: > Hi, > Have you already tried this out? > > select MAX(page_count_count) - MIN(page_count_count) from page_count group > by page_count_pdate. > > > Best, > Oliveiros
Oliveiros, Thx that mostly works. I just tried it and on the days there is only 1 entry it is 0 since max is the same as min so max - min is 0. Is there a way to take in to account the 1 entry days? Again thx - I appreciate your help :) -wes -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
