0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for self-employed and freelance workers

SELECT 
z.tags2 AS [Tags]
,[NumberOfTags]
, [PostID]
, [UserID]
, [PostBody]
FROM (
SELECT 
p.tags
,STRING_AGG(p.tags, '<>') AS [Tags2]
,LEN(p.Tags) - LEN(REPLACE(p.Tags, '<','')) AS [NumberOfTags]
,p.id AS [PostID]
,p.OwnerUserID AS [UserID]
,p.body AS [PostBody]

FROM posts p
WHERE p.id = 3335954 --4

group by p.id
,p.tags
,p.id 
,p.OwnerUserID 
,p.body 

) z

fork query

edited may 20

created jul 2 21 anonymous