Self answers

1

Please login or register to vote for this query.

(click on this box to dismiss)

Finds self-answered questions, with adjustable parameters for minimum and maximum total score, and time separation between the question and the answer. Excludes community wiki posts.

Stack Overflow

Q&A for professional and enthusiast programmers

Select Top ##NumerOfPosts?20##
  Questions.Id AS [Post Link],
  Questions.Score AS "Q Score",
  Answers.Score AS "A Score",
  Questions.Score+Answers.Score AS "Total Score",
  DATEDIFF(ss,Questions.CreationDate,Answers.CreationDate) AS "Time separation"
FROM
  Posts Questions
INNER JOIN
  Posts Answers
  ON Answers.ParentId=Questions.Id
WHERE Answers.OwnerUserId=Questions.OwnerUserId
  AND Questions.CommunityOwnedDate IS NULL
  AND DATEDIFF(ss,Questions.CreationDate,Answers.CreationDate)<##MaxTimeSeparationInSeconds?300##
  AND Questions.Score+Answers.Score > ##MinTotalScore?-100##
  AND Questions.Score+Answers.Score < ##MaxTotalScore?1000##
ORDER BY Questions.Score+Answers.Score DESC

Enter Parameters

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