0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT TOP 20 Title, ViewCount, AnswerCount, PostTypeId
FROM Posts as P, PostTags as PT
WHERE P.Id=PT.PostId and PT.TagId = 3

SELECT TOP 20 Title, ViewCount, AnswerCount, postTypeId
FROM Posts 
WHERE id IN (SELECT PostId FROM PostTags WHERE TagId = 3)

fork query

edited sep 9 18

created sep 8 18 anonymous