select top 20 posts.id, posts.id as [Post Link], posts.cr...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 20
posts.id,
posts.id as [Post Link],
posts.creationdate,
commentcount
from posts
where posttypeid=1

Enter Parameters

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