Strawberry Shortcake

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

-- This will only query within Stack Overflow, not across other exchanges,
-- e.g. Wordpress Stack Exchange.

SELECT -- TOP ##Limit:int?40##
  p1.Id AS [Post Link], p2.Id AS [Post Link]
FROM Posts p1
  INNER JOIN Posts p2 ON p1.Body = p2.Body
WHERE p1.PostTypeId = 2 AND p2.PostTypeId = 2 -- answers
  AND p1.Id <> p2.Id
  AND p1.OwnerUserId <> p2.OwnerUserId
  AND p1.OwnerUserId = ##UserId:int##
  -- AND p1.CreationDate BETWEEN ##StartDate:string?2014-06-01## AND ##EndDate:string?2014-08-12##
ORDER BY p1.CreationDate DESC

Enter Parameters

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