0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for science fiction and fantasy enthusiasts

Select  row_number() over(order by count(postId) desc) tagID, tagname,
 count(postid) 
From PostTags p
inner join tags t
on p.tagId = t.id
Group by tagname

fork query

created apr 14 11 conradfrix