SQL subquery with COUNT help

April 15, 2023 by Tarik

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"