Q&A about the site for people interested in improving and participating in the patent system
WITH MyCTE AS( SELECT ROW_NUMBER() OVER(ORDER BY Id ASC) AS RowNum, * FROM POSTS WHERE PostTypeId = 1 AND CreationDate BETWEEN '10/01/2018 00:00:01' and '12/31/2018 23:59:59' AND LastEditDate IS NULL AND ViewCount > 0 AND DeletionDate IS NULL ) SELECT Id,AcceptedAnswerId,Score,ViewCount,Body,Title,Tags,AnswerCount,CommentCount,FavoriteCount,ClosedDate FROM MyCTE WHERE RowNum <=40000