0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people seeking specific software recommendations

WITH posts_with_total_2_tags AS
(
SELECT TOP 100 PostId, COUNT(TagId) as tag_count
FROM PostTags
GROUP BY PostId
HAVING COUNT(TagId) = 2
)
SELECT 
*, 
row_number() OVER (PARTITION BY PostId ORDER BY PostId)
FROM posts_with_total_2_tags

view current version

edited dec 6

created dec 6 user28646684