0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

-- Four major RDBMS systems, ranked by popularity

SELECT  TagName AS Tags,
        cnt AS [Questions Tagged],
        ROUND(100.0 * cnt / SUM(cnt) OVER (), 2) AS [Ratio, %]
FROM    Tags t
CROSS APPLY
        (
        SELECT  COUNT(*) AS cnt
        FROM    PostTags pt
        WHERE   pt.TagId = t.id
        ) q
WHERE   t.TagName IN ('mysql', 'sql-server', 'oracle', 'postgresql')
ORDER BY
        cnt DESC

fork query

created may 30 10 Quassnoi