0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for administrators and users of the CiviCRM Constituent Relationship Management software

/*
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;

fork query

edited nov 4 jon.doe46194

created nov 4 anonymous