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