0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

SELECT TOP 1000
  q.Id AS [Post Link],
  q.Title AS [Question Title],
  q.Body AS [Question Body],
  a.Id AS [Answer Link],
  a.Score AS [Answer Score],
  a.CreationDate AS [Answer CreationDate],
  a.OwnerUserId AS [User Link],
  a.Body AS [Answer Body]
FROM Posts a
JOIN Posts q ON q.Id = a.ParentId
WHERE a.PostTypeId = 2
ORDER BY a.Score DESC;

fork query

edited sep 26 23

created sep 26 23 anonymous