Q&A about the site for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more
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;