0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for SharePoint enthusiasts

--SELECT*
--FROM Tags
--WHERE TagName='delimited'
--ORDER BY COUNT DESC

--Sinonīmu lietojums
--SELECT*
--FROM TagSynonyms
--WHERE (TargetTagName='html' OR TargetTagName='css')

--posts un tā tagi(detalizēti)
--SELECT*
--FROM PostTags
--WHERE PostId IN (14, 66, 72)
--ORDER BY PostId ASC

--Cik ir unikālo postu ar Tagiem? 24 124 389
--SELECT COUNT (DISTINCT PostId)
--FROM PostTags

--Visi posti, kuriem ir 2 tagi (kombinācijas, vairāk kā 50000 rindu)
--SELECT PostId, COUNT(*)
--FROM PostTags
--GROUP BY PostId
--HAVING COUNT(*)=2
--ORDER BY PostId ASC

SELECT PostTags.PostId, Posts.Id, Posts.Tags, COUNT(*)
FROM PostTags, Posts
WHERE PostTags.PostId=Posts.Id
GROUP BY PostTags.PostId, Posts.Id, Posts.Tags
HAVING COUNT(*)=2
ORDER BY PostTags.PostId ASC

fork query

edited apr 16

created apr 16 jon.doe44367