Re: group by hour + distinct - Mailing list pgsql-sql

From Michele Petrazzo - Unipex
Subject Re: group by hour + distinct
Date
Msg-id 4CEFAB4F.6000109@unipex.it
Whole thread Raw
In response to Re: group by hour + distinct  ("Oliveiros d'Azevedo Cristina" <oliveiros.cristina@marktest.pt>)
Responses Re: group by hour + distinct  (Lew <noone@lewscanon.com>)
List pgsql-sql
Oliveiros d'Azevedo Cristina ha scritto:
> Howdy, Michelle,
>

Ciao

> for each hour it will count the number of distinct user_id's there
> are . If I understood correctly what you need...
>
> Can you please test it and see if it is OK for your needs? With me,
> it worked on the sample data you provided
>

Yes! Simply perfect!

> Best, Oliver
>

Thanks,
Michele

P.s. Have you some references about the "subquery" keyword? I found only
the word subquery as "use" (for example: select a from b where id in 
(select id from table)), but not as sql command.



pgsql-sql by date:

Previous
From: "Oliveiros d'Azevedo Cristina"
Date:
Subject: Re: group by hour + distinct
Next
From: "Oliveiros d'Azevedo Cristina"
Date:
Subject: Re: group by hour + distinct