Four major RDBMS systems, ranked by popularity

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

-- 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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results