select top(10) * from Posts pst where exists (select PostId

0

Please login or register to vote for this query.

(click on this box to dismiss)

Webmasters

Q&A for pro webmasters

select top(10) *
  from Posts pst
 where exists (select PostId
                 from PostTags ptg
                 join Tags tg on ptg.TagId = tg.Id
                where pst.Id = ptg.PostId
                  and tg.TagName = 'html'
                )
   and exists (select PostId
                 from PostTags ptg
                 join Tags tg on ptg.TagId = tg.Id
                where pst.Id = ptg.PostId
                  and tg.TagName = 'css'
                )
order by pst.Id

Enter Parameters

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