with x as ( select top 20 posts.id, posts.id as [Post Lin...

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

with x as (
select top 20
posts.id,
posts.id as [Post Link],
posts.creationdate,
commentcount
from posts
where posttypeid=1)
select * from x
where commentcount>0

Enter Parameters

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