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
  answers.Score,
  answers.Score AS Votes,
  questions.Title AS QuestionTitle,
  questions.AcceptedAnswerId AS AcceptedAnswer,
  answers.Id AS MostVotedAnswer,
  answers.Score AS Votes
FROM Posts questions
INNER JOIN (
  SELECT TOP 1
    *
  FROM Posts p
  ORDER BY p.Score DESC
) AS 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