0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for science fiction and fantasy enthusiasts

SELECT  PostId, Comment
FROM (select TOP 10 PostId, Comment,
             ROW_NUMBER() OVER (PARTITION BY PostId ORDER BY CreationDate desc) AS rownum
             FROM PostHistory) ph
WHERE rownum = 1;

fork query

edited nov 4 jon.doe46194

created nov 4 anonymous