SELECT PostId, COUNT(*) FROM PostTags GROUP BY PostI...

0

Please login or register to vote for this query.

(click on this box to dismiss)

SharePoint

Q&A for SharePoint enthusiasts

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

--SELECT*
--FROM PostTags
--ORDER BY PostId ASC

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

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


SELECT PostId, COUNT(*)
FROM PostTags
GROUP BY PostId
HAVING COUNT(*)=2
ORDER BY PostId ASC

Enter Parameters

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