1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in the history and origins of science and mathematics

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

fork query

edited oct 14

created oct 14 zcoop98