0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for SharePoint enthusiasts

select * 
from (
select postid, id, creationdate,
row_number() over (
    partition by postid
    order by creationDate desc) as _rn
from comments
) t1
WHERe t1._rn = 1;

fork query

edited oct 16

created oct 15 jon.doe46027