Top Tag users (score > 0)


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

declare @tag_id int = (select id from tags where tagname = LOWER('##TagName##'));

select top (##Limit##)
  rank() over (order by sum(answers.score) desc) "Rank", as [User Link],
  sum(answers.score) as "Score"
from users
join posts answers on ( = answers.owneruserid)
join posts parent on (answers.parentid =
join posttags on ( = posttags.postid)
where posttags.tagid = @tag_id and answers.score > 0

group by
order by sum(answers.score) desc;

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results