Better Questions than Answers


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 BestScores as (
select ParentId, max(Score) MaxScore
from Posts A
where PostTypeId = 2
  and Score > 50
group by ParentId
Select id as [Post Link], Title, Score, MaxScore
from Posts Q inner join BestScores on ID = BestScores.ParentId and Score > MaxScore
order by Score DESC, MaxScore DESC

Enter Parameters

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