Should we be notified if an answer to a question we asked has a higher score than the accepted answe

0

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackoverflow.com/questions/371621/should-we-be-notified-if-an-answer-to-a-question-we-asked-has-a-higher-score-tha

Stack Overflow

Q&A for professional and enthusiast programmers

select q.id [Post Link]
     , min(acc.score) [score accepted answer]
     , max(a.score) [score top answer]
from posts q
inner join posts acc 
        on acc.id = q.acceptedanswerid
inner join posts a 
        on a.parentid = q.id and a.id <> acc.id
where q.posttypeid = 1
and q.owneruserid = ##userid:int?160527##
group by q.id
having min(acc.score) < max(a.score)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results