Self-answered Q&As by score

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

SELECT
  q.Id AS [Post Link],
  q.OwnerUserId AS [User Link],
  q.Score AS 'Q score',
  a.Score AS 'A score',
  q.CreationDate
FROM Posts q
JOIN Posts a ON a.ParentId = q.Id
WHERE q.OwnerUserId = a.OwnerUserId
  AND DATEDIFF(s,q.CreationDate,a.CreationDate) < 5
ORDER BY q.Score DESC

Enter Parameters

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