SELECT TOP 100 TagName AS Tag, PT.C AS Count FROM Tags T ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Enter Query Title
-- Enter Query Description
SELECT TOP 100
    TagName AS Tag,
    PT.C AS Count
FROM Tags T
INNER JOIN 
    (SELECT TagId, C = Count(*)
    FROM PostTags
    GROUP BY TagId) PT ON T.Id = PT.TagId
WHERE PT.C > 500
ORDER BY PT.C ASC

Enter Parameters

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