Select P.OwnerDisplayName, P.Title, P.LastEditDate, ROW_N...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping

Q&A for gardeners and landscapers

Select
  P.OwnerDisplayName,
  P.Title,
  P.LastEditDate,
  ROW_NUMBER() OVER(PARTITION BY P.OwnerDisplayName
                          ORDER BY P.LastEditDate DESC) as RNR
 From
   Posts P
 where
 P.OwnerDisplayName is not null
   and
 P.LastEditDate>DATEADD(month, -3,GETDATE())
   and
 P.ViewCount>0

Enter Parameters

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