SQL subquery with COUNT help

Question

I have an SQL statement that works  SELECT   FROM eventsTable WHERE columnName  Business    I want to add this as a subquery     COUNT Business  AS row count   How do I do this

User · Answer

Assuming there is a column named business   SELECT Business  COUNT    FROM eventsTable GROUP BY Business

User · Answer

This is probably the easiest way  not the prettiest though   SELECT         SELECT Count    FROM eventsTable WHERE columnName    Business   as RowCount     FROM eventsTable     WHERE columnName    Business    This will also work without having to use a group by  SELECT    COUNT    OVER    as RowCount     FROM eventsTables     WHERE columnName    Business

User · Answer

SELECT e           cnt colCount  FROM eventsTable e INNER JOIN              select columnName count columnName  as colCount            from eventsTable e2            group by columnName              as cnt on cnt columnName   e columnName WHERE e columnName  Business    -- Added space

User · Answer

Do you want to get the number of rows   SELECT columnName  COUNT    AS row count FROM eventsTable WHERE columnName    Business  GROUP BY columnName

[sql] SQL subquery with COUNT help

Examples related to sql