SELECT TOP 100 * FROM Posts p1 INNER JOIN Posts p2 ...

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 100 *

FROM Posts p1

INNER JOIN Posts p2      ON p1.Id = p2.ParentId
INNER JOIN PostTags pt   ON p2.Id = pt.PostId
--JOIN Tags t        ON t.Id = pt.TagId

WHERE 
--p1.PostTypeId = 2 
--  and p1.CommunityOwnedDate is null 
  --and p1.ClosedDate is null
  p1.CreationDate < '2018-07-01'
  and p1.CreationDate >= '2017-01-01'

--GROUP BY
--t.TagName

--ORDER BY
--jun18

Enter Parameters

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