Select All Posts


Please login or register to vote for this query.

(click on this box to dismiss)

Italian Language Meta

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

WITH allData AS (
                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

Switch sites:
loading Hold tight while we fetch your results