SELECT top 5 P.id, count(1) FROM Posts P INNER JOIN PostT...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Chess Meta

Q&A about the site for serious players and enthusiasts of chess

SELECT top 5 P.id, count(1)
FROM Posts P
INNER JOIN PostTags PT ON PT.PostId = P.Id
INNER JOIN Tags T ON T.Id = PT.TagId
WHERE T.TagName IN ('html','css')
group by P.id
having count(1) =1

Enter Parameters

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