postgres-window-function.sql

SELECT DISTINCT comments.id, comments.content_id, comments.created_at -- whatever fields you like
  FROM comments
  INNER JOIN (
    SELECT comments.id, first_value(comments.id)
    OVER (PARTITION BY content_id ORDER BY created_at DESC) comment_id
    FROM comments
  ) chosen
  ON chosen.comment_id = comments.id