Re: how to construct sql

From: Wes James <comptekki(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: how to construct sql
Date: 2010-06-02 17:31:01
Message-ID: AANLkTikQCTiXkz0n2wPp_kvK6KIf-rXngFb_7UDdfb0y@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, Jun 2, 2010 at 10:55 AM, Oliveiros
<oliveiros(dot)cristina(at)marktest(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Plugge, Joe R. 2010-06-02 19:51:35 Re: how to construct sql
Previous Message Hiltibidal, Rob 2010-06-02 17:06:13 Re: how to construct sql