Dup Questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Engineering

Q&A for professionals and students of engineering

SELECT TOP 10
  questions.Id AS QuestionId,
  questions.Title AS QuestionTitle,
  questions.AcceptedAnswerId AS AcceptedAnswer,
  answers.Id AS MostVotedAnswer,
  answers.Score AS Votes
FROM Posts questions
INNER JOIN PostHistory history ON questions.Id = history.PostId
INNER JOIN (
  SELECT DISTINCT
    p.Id,
    p.ParentId,
    p.Score
  FROM Posts p
  WHERE p.ParentId IS NOT NULL
) AS answers ON questions.Id = answers.ParentId
WHERE (
  questions.Id = 14
)

Enter Parameters

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