Get Top 100 Highest Scoring Q's & A's

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

SELECT TOP 100
p.Id AS [Post Link],
pt.Name AS 'Post Type',
p.Score,
p.ViewCount AS 'Views'
FROM Posts p
JOIN PostTypes pt ON p.PostTypeId = pt.Id
-- Limit post types to Qs and As only
WHERE p.PostTypeId = 1 OR p.PostTypeId = 2
ORDER BY p.Score DESC

Enter Parameters

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