DISTINCT ON with aggregate function

Asked Aug 23 '17 at 17:50

Active Aug 23 '17 at 17:50

Viewed 154 times

I want to get the project with the highest number of views for each user in Postgres. This is the code I have so far:

  SELECT DISTINCT ON (user_id)
    project, user_id, COUNT(view_id) views
  FROM
    table_name
  GROUP BY
    user_id
  ORDER BY
    user_id, views DESC, project

asked Aug 23 '17 at 17:50

Marco Greselin

Please explain the problem you're experiencing and update the question. – Tim Ferrell Aug 23 '17 at 17:54
And what is the question ? – krokodilko Aug 23 '17 at 18:50

DISTINCT ON with aggregate function

0 Answers0