Better Questions than Answers

1

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

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