select top 10 postid, id from comments order by postid, r...

0

Please login or register to vote for this query.

(click on this box to dismiss)

SharePoint

Q&A for SharePoint enthusiasts

select top 10 postid, id
from comments
order by postid, 
  row_number() over (
    partition by postid
    order by creationDate desc)

Enter Parameters

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