0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for operations research and analytics professionals, educators, and students

declare @TagString nvarchar(25) = ##tagName:string##

select ViewCount, Title, CreationDate
from Posts 
where Id in
  (
    select PostId 
    from PostTags 
    where TagId =
    (
      select Id 
      from Tags 
      where TagName = @TagString
     )
  )
Group by ViewCount, Title, CreationDate
ORDER by ViewCount DESC

fork query

edited mar 6 12

created mar 6 12 anonymous