Highest scored double / multiple answers


Please login or register to vote for this query.

(click on this box to dismiss)

Space Exploration

Q&A for spacecraft operators, scientists, engineers, and enthusiasts

-- Finds questions that have multiple answers by the same user,
-- in descending order by minimum answer score.

Select Top 1000
  Q.Id as [Post Link],
  A.OwnerUserId as [User Id],
  A.OwnerUserId as [User Link],
  Count(*) as Answers,
  Min(A.Score) as MinScore,
  Max(A.Score) as MaxScore
  Posts as Q
  Join Posts as A On A.ParentId = Q.Id
  Q.PostTypeId = 1 and A.PostTypeId = 2
  and A.OwnerUserId is not null
Group By
  Q.Id, A.OwnerUserId
Having Count(*) > 1
Order By MinScore Desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results