0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for pro webmasters

SELECT TOP 50000
    p.Id,
    p.PostTypeId,
    p.ParentId,
    p.CreationDate,
    p.Score,
    p.ViewCount,
    p.Title,
    p.Tags,
    p.Body,
    p.OwnerUserId,
    p.AnswerCount,
    p.CommentCount,
    p.FavoriteCount
FROM
    Posts AS p
WHERE
    p.CreationDate >= '2021-05-01' AND p.CreationDate < '2021-06-01'
    AND p.PostTypeId IN (1, 2) -- 1: 问题, 2: 答案
ORDER BY
    p.CreationDate ASC

fork query

edited nov 12

created nov 12 anonymous