select pst.* from Posts pst join PostTags ptg on pst.Id =...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Quantitative Finance Meta

Q&A about the site for finance professionals and academics

select pst.*
from Posts pst
join PostTags ptg on pst.Id = ptg.PostId
JOIN Tags t ON (ptg.TagId = t.Id)
where pst.CreationDate >= '2024-01-01 00:00:00'
  and pst.CreationDate < '2024-01-02'
  and pst.Id >= 77734096
  and t.TagName = 'c#'
order by id

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results