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)

Web Applications Meta

Q&A about the site for power users of web applications

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

Enter Parameters

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