SELECT TOP(20) * FROM Posts posts JOIN Posts answers ON p...

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(20) * 
FROM Posts posts
JOIN Posts answers ON posts.AcceptedAnswerId=answers.Id
WHERE 
posts.Tags like '%<python>%' and posts.PostTypeId=1
and posts.CreationDate>Convert(datetime, '2015-01-01' )
ORDER BY posts.score DESC;

Enter Parameters

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