Postgresql query advice

Question

I need to find out the amount of people that made their first post during a selected day. I have a table that contains all the posts that everyone made. So my logic was to get all the people that did only one post, and this post is done yesterday. I tried some queries, but I still dont feel very comfortable with Postgresql, so please help.

Those are the fields that i have available:

user_id
post_id
post_date

podiluska · Accepted Answer · 2012-08-30 08:01:51Z

4

SELECT user_id, min(post_date) 
from table
group by user_id
having min(post_date) = YourSelectedDate

answered Aug 30, 2012 at 8:01

podiluska

51.6k7 gold badges102 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql query advice

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related