0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for pro webmasters

-- 获取2020-2021年评分最高的100个问题
SELECT TOP 100
  Id as [Post Link],  -- 这会自动生成链接
  Title,
  CreationDate,
  Score,
  ViewCount,
  AnswerCount,
  Tags
FROM Posts
WHERE PostTypeId = 1  -- 1 表示问题
  AND YEAR(CreationDate) BETWEEN 2020 AND 2021
ORDER BY Score DESC

view current version

edited nov 12

created nov 12 anonymous