Where did I win?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Finds all questions where your answer is the highest-voted but there are still other answers.

Engineering

Q&A for professionals and students of engineering

SELECT Id [Post Link] FROM Posts AS Answer
  WHERE PostTypeId = 2
  AND OwnerUserId = ##UserId##
  AND Score > 0
  AND Id = (SELECT TOP(1) Id FROM Posts AS AllAnswers WHERE AllAnswers.ParentId = Answer.ParentId ORDER BY AllAnswers.Score DESC)
  AND (SELECT AnswerCount FROM Posts AS Question WHERE Question.Id = Answer.ParentId) > 1
  ORDER BY Score DESC

Enter Parameters

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