Most Down-Voted Questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

The top 20 questions with the most down-votes (ignores up-votes)

Board and Card Games

Q&A for people who like playing board games, designing board games or modifying the rules of existing board games

/*
select PostId AS [Post Link], max(CreationDate) as 'last_comment'
from (select top 50 * from comments) c
group by PostId;
*/

select c1.PostId, c1.text, c1.CreationDate
from comments c1
inner join(
   select PostId, max(CreationDate) as 'last_comment'
   from comments
   group by PostId
) c2 on c1.PostId = c2.PostId and c1.CreationDate = c2.last_comment ;

Enter Parameters

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