0

Please login or register to vote for this query.

(click on this box to dismiss)

Probably not the most efficient way... ordered by creation views

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

select top 100  p.id as [Post Link],p.title,p.id,p.body,p.OwnerUserId,p.ParentId, p.tags, p.AnswerCount,p.AcceptedAnswerId,p.score, p.CreationDate from posts as p
where (p.posttypeid=2)
 and CreationDate > '2018-12-31'
 and CreationDate < '2019-01-31'

fork query

edited dec 9 19 jon.doe32808

created oct 26 11 burpenator