0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for users of Ethereum, the decentralized application platform and smart contract enabled blockchain

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

fork query

edited nov 12

created nov 12 anonymous