SO posts with highest score

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

select top 500 Id as [Post Link], Score, ViewCount, (select count(*) from Votes where Votes.PostId = Posts.Id and Votes.VoteTypeId = 2 GROUP BY Votes.PostId) as UpVotes From Posts
order by Score desc

Enter Parameters

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