Getting downvoters for a post


Please login or register to vote for this query.

(click on this box to dismiss)

The query shall fetch down voters to a post.

Music Fans

Q&A for music historians, critics, and fans

DECLARE @postID INT = ##PostID##

--  p.Id,
--  v.UserID,
--  u.DisplayName AS [Name],
--  CASE v.VoteTypeId 
--    WHEN 2 THEN 'Upvote'
--    WHEN 3 THEN 'Downvote'
--  END AS [Vote Type]
FROM Votes v
WHERE v.PostId = @postID;

Enter Parameters

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