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)

Ethereum Meta

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-2-01' AND p.CreationDate < '2024-3-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