0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for designers and users of artificial or invented languages, consciously developed instead of having developed naturally

SELECT Id, PostTypeId, CreationDate, Score, ViewCount, Tags, AnswerCount, FavoriteCount
  FROM posts
  WHERE PostTypeId = 1 AND CHARINDEX('2019', CreationDate) > 0
  ORDER BY Score DESC;

fork query

edited sep 19 20

created sep 19 20 Pavan.Kumar