0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people looking to bypass life's everyday problems with simple tricks

SELECT top 10 p.Id, count(1)
FROM Posts p,
     PostTags pt,
     Tags t
WHERE p.Id = pt.PostId
AND pt.TagId = t.Id
AND t.TagName IN ('html','css')
group by p.Id
having count(1) > 1

view current version

edited nov 8

created nov 8 Janis123