Users with only one question and an accepted self-answer

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 10 u.Id AS [User Link]
  FROM Users AS u
  INNER JOIN Posts AS q
    ON q.OwnerUserId = u.Id
  INNER JOIN Posts AS a
    ON q.AcceptedAnswerId = a.Id AND a.OwnerUserId = u.Id
  LEFT OUTER JOIN Posts AS p
    ON p.OwnerUserId = u.Id AND p.Id NOT IN (a.Id, q.Id)
  WHERE p.Id IS NULL

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results