Get body of all accepted answers in 2019

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT a.Id, a.Body
FROM Posts q
INNER JOIN Posts a on q.AcceptedAnswerId = a.Id
WHERE year(a.CreationDate)=2019
      and q.PostTypeId = 1
      and a.PostTypeId = 2 -- answers
ORDER BY Id
OFFSET 50000 * 14 ROWS FETCH NEXT 50000 ROWS ONLY

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results