Re: how to construct sql

Поиск
Список
Период
Сортировка
От Wes James
Тема Re: how to construct sql
Дата
Msg-id AANLkTikQCTiXkz0n2wPp_kvK6KIf-rXngFb_7UDdfb0y@mail.gmail.com
обсуждение исходный текст
Ответ на Re: how to construct sql  ("Oliveiros" <oliveiros.cristina@marktest.pt>)
Ответы Re: how to construct sql
Список 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 по дате отправления:

Предыдущее
От: "Oliveiros"
Дата:
Сообщение: Re: how to construct sql
Следующее
От: Justin Graf
Дата:
Сообщение: Re: how to construct sql