1st task

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

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;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results