0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those who study, teach, research and apply economics and econometrics

SELECT TOP 10
  p.Id AS Post,
  p.Title AS Question,
  p.AcceptedAnswerId AS AcceptedAnswer,
  a.Answer AS MostVotedAnswer,
  a.Votes AS Votes
FROM Posts p
INNER JOIN PostHistory h ON p.Id = h.PostId
INNER JOIN (
  SELECT TOP 100
    answers.ParentId AS Question,
    answers.Id AS Answer,
    answers.Score AS Votes
  FROM Posts answers
) AS a ON p.Id = a.Question

fork query

edited aug 24 13

created aug 15 13 anonymous