progress towards Self Learner badge

4

Please login or register to vote for this query.

(click on this box to dismiss)

Shows the scores for answers you've given to your own questions

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

DECLARE @user INT = ##UserID:int##

select
    Answer.Id as [Post Link],
    Answer.Score
from Posts as Answer
LEFT JOIN Posts as Question on Question.Id=Answer.ParentId
WHERE Answer.PostTypeId=2
    and Answer.OwnerUserId=@user
    and Question.OwnerUserId=@user
ORDER BY Score DESC

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results