Search for question with positive score where all answers have zero score


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 1000 as [Post Link]
     , q.score [question score]
     , q.answercount
     , q.creationdate
from posts q 
where q.score > 0               -- positive scoring question
and q.answercount > 0           -- with at least one answer
and q.acceptedanswerid is null  -- no accepted answer
and (select count(*) 
     from posts 
     where posttypeid = 2
     and parentid =
     and score  = 0) = q.answercount -- all answers score zero
order by q.creationdate desc

Enter Parameters

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