QueryResult1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Data

Q&A for developers and researchers interested in open data

WITH TagList AS (
    SELECT Id,
           TRIM(value) AS Tag
    FROM Posts
    CROSS APPLY STRING_SPLIT(Tags, '>') 
    WHERE YEAR(CreationDate) = 2023
)
SELECT Tag,
       STRING_AGG(CAST(Id AS NVARCHAR(MAX)), ',') AS PostIDs
FROM TagList
GROUP BY Tag;

Enter Parameters

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