SQL query for active users

Posted by user344513 on Stack Overflow See other posts from Stack Overflow or by user344513
Published on 2010-05-18T21:23:29Z Indexed on 2010/05/18 21:30 UTC
Read the original article Hit count: 269

Filed under:
|

This SQL query gives me today's number of users active in the last 30 days:

SELECT COUNT(*) FROM table.users WHERE creation_tsz >= (now() - interval '30 days')

How can I modify it to get not a single value, but a table of active users for a range of dates?

Thanks,

Rob

© Stack Overflow or respective owner

Related posts about sql

Related posts about query