0

Please login or register to vote for this query.

(click on this box to dismiss)

プログラマーとプログラミングに熱心な人々のための質問と回答

SELECT v.PostId, v.VoteTypeId, t.Name, v.CreationDate, v.BountyAmount,
CASE  
    WHEN v.VoteTypeId IN (1) THEN 15
    WHEN v.VoteTypeId IN (2) THEN 10
    WHEN v.VoteTypeId IN (3) THEN -2
    Else 0
END AS Answer1
FROM Votes v
JOIN VoteTypes t ON v.VoteTypeId = t.Id
WHERE PostId IN (
SELECT Id
FROM Posts
WHERE OwnerUserId = ##UserId##)
ORDER BY v.CreationDate

fork query

edited apr 13

created apr 13 anonymous