0

Please login or register to vote for this query.

(click on this box to dismiss)

プログラマーとプログラミングに熱心な人々のための質問と回答

declare @MonthsAgo date = cast(dateadd(month, -2, getdate()) as date)

select vote.PostId, post.Score, post.CreationDate from votes vote
  inner join posts post on post.Id = vote.PostId
  where post.CreationDate >=  ##SinceDate:string?@MonthsAgo## and Tags like '%java%'
order by post.Score desc

fork query

edited jan 27 20 Serkan.Arslan

created jan 26 20 anonymous