Q&A about the site for software quality control experts, automation engineers, and software testers
/* 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, CreationDate from (select PostId, Comment,CreationDate, row_number() over (order by CreationDate desc) as rownum from PostHistory where PostId = '356123') g where rownum = 1;