Q&A for science fiction and fantasy enthusiasts
/* select * from posts where Id = 356123; select * from SuggestedEdits where PostId = 356123; select * from ReviewTasks rt inner join ReviewTaskResults rtr on rt.Id = rtr.ReviewTaskId where rt.PostId = 356123; select * from PostHistory where PostId = 356123;*/ select top 10 PostId, Comment from (select PostId, Comment, row_number() over (partition by PostId order by CreationDate desc) as rownum from PostHistory) ph where rownum = 1;