Ciao
* Olá!
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!
* Great to hear it worked !
Thanks,
Michele
* Don't mention it ;-)
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.
* I don't know subquery as an SQL keyword too. In the query I gave you the
"subquery" thing was just an alias. Such kind of things are mandatory. If I
try to omit it, I get this error
ERROR: subquery in FROM must have an alias
HINT: For example, FROM (SELECT ...) [AS] foo.
********** Erro **********
ERROR: subquery in FROM must have an alias
Estado de SQL:42601
Sugestão:For example, FROM (SELECT ...) [AS] foo.
So, even though the "subquery" alias was not used anywhere else, I believe
it had to be there, otherwise the SQL parser would complain
Best,
Oliver
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
