Answers (by year)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Retrieve all answers of a user by year

Software Engineering

Q&A for professionals, academics, and students working within the systems development life cycle

SELECT
    a.Id AS [Post Link],
    a.Id,
    q.Title,
    a.CreationDate,
    a.Score,
    q.ViewCount AS [Views],
    CASE WHEN a.Id = q.AcceptedAnswerId THEN 1 ELSE 0 END AS Accepted,
    q.Tags
 FROM Posts a
 LEFT JOIN Posts q ON q.Id = a.ParentId
WHERE a.PostTypeId = 2 -- Answer
  AND a.OwnerUserId = ##UserId##
  AND Year(a.CreationDate) = ##Year##
ORDER BY a.CreationDate DESC

Enter Parameters

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