4

Please login or register to vote for this query.

(click on this box to dismiss)

This query doesn't care how many votes you've cast overall (though it does display your percentage) but rather it looks at the total number of downvotes.

Q&A for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition

-- Who has cast the most downvotes?
-- This query doesn't care how many votes you've cast overall (though it does display your percentage) but rather it looks to see the total number of downvotes.
select top 500 
  Id as [User Link],
  UpVotes,
  DownVotes,
  ((DownVotes*100) / (DownVotes + UpVotes) )  As PercentageDown
  from Users c  
where DownVotes > 10
order by DownVotes desc

fork query

created dec 22 10 gregory.auger