0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

--DECLARE @Tag varchar(35) = ##Tag##

--SELECT count(*)
--FROM (
SELECT --TOP 10
  PostTags.PostId, Posts.Tags, COUNT(Tags.TagName) AS cnt
FROM PostTags
  JOIN Tags ON PostTags.TagId = Tags.Id 
    AND Tags.TagName IN ('realm', 'ios', 'swift')
  JOIN Posts ON PostTags.PostId = Posts.Id
GROUP BY
  PostTags.PostId, Posts.Tags
  HAVING COUNT(Tags.TagName) >= 3
  --) a

view current version

edited jul 24 19

created jul 24 19 kevinadi