1

Please login or register to vote for this query.

(click on this box to dismiss)

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

select parent.id as [Post Link], comments.id as [Comment Id], comments.score as [Score] from comments join (select p.id from posts p inner join users u 
on (p.ownerUserId=u.id) 
and (DATEDIFF(d, u.CreationDate, p.CreationDate) < 3)
where p.postTypeId = 1) parent 
ON parent.id = comments.postId 
and comments.userId=##UserId##
order by comments.score desc;

fork query

edited jul 25 12

created jul 25 12 Mark Peters