select top 10 Tags,* from Posts where creationdate be...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

--) What are the top 10 tags associated with posts created in 2017?


--select distinct TagID from PostTags


select top 10 Tags,* from Posts
where creationdate between '2017-01-01' AND '2017-12-31'

select b.* from Posts a
left join PostTags b on a.id = b.postid
where creationdate between '2017-01-01' AND '2017-12-31'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results