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 DISTINCT
  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 Posts answers ON answers.ParentId = questions.Id
WHERE (
  questions.Id = 14
)
ORDER BY answers.Score DESC

Enter Parameters

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