SELECT TOP 50000 p.Id, p.PostTypeId, p.ParentId, p.Creati...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Webmasters

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 >= '2023-05-01' AND p.CreationDate <= '2023-5-30'
    AND p.PostTypeId IN (1, 2) -- 1: 问题, 2: 答案
ORDER BY
    p.CreationDate ASC

Enter Parameters

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