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?

Answer 1

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' 

Answer 2

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