0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for science fiction and fantasy enthusiasts

-- 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 ('adminer', 'phpmyadmin', 'navicat', 'sqlyog'
        , 'sqlbuddy', 'toad', 'dbninja', 'sqlwave', 'chive', 'dbvisualizer'
        ,'sql-maestro', 'squirrel-sql', 'razorsql', 'aqua', 'db-forge')
ORDER BY
        cnt DESC
       


/*
DbNinja
SQLWave
chive
DbVisualizer
SQL Maestro
SQuirrel SQL
RazorSQL
Aqua
dbForge Studio*/

fork query

edited jul 11 13 anonymous

created may 30 10 Quassnoi