Re: how to construct sql - Mailing list pgsql-sql

From Wes James
Subject Re: how to construct sql
Date
Msg-id AANLkTikQCTiXkz0n2wPp_kvK6KIf-rXngFb_7UDdfb0y@mail.gmail.com
Whole thread Raw
In response to Re: how to construct sql  ("Oliveiros" <oliveiros.cristina@marktest.pt>)
Responses Re: how to construct sql  (Justin Graf <justin@magwerks.com>)
List pgsql-sql
On Wed, Jun 2, 2010 at 10:55 AM, Oliveiros
<oliveiros.cristina@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


pgsql-sql by date:

Previous
From: "Oliveiros"
Date:
Subject: Re: how to construct sql
Next
From: Justin Graf
Date:
Subject: Re: how to construct sql