Select All Posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Skeptics

Q&A for scientific skepticism

WITH allData AS (
    SELECT
                ROW_NUMBER() OVER (ORDER BY P.Id) AS row
                , P.Id
                , P.PostTypeId
                , P.ParentId
                , P.AcceptedAnswerId
                , P.CreationDate
                , P.OwnerUserId
                , P.Tags
                , P.ClosedDate
    FROM        Posts    AS P
    WHERE       YEAR(P.CreationDate) = 2020 AND MONTH(P.CreationDate) = 1
)
SELECT      *
FROM        allData
WHERE       row    >= 1 + 50000*(##StartRow:INT?1## - 1)
ORDER BY    row

Enter Parameters

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