ansaurus

Question

Answer 1

+3 A:

Do you want to get the number of rows?

SELECT columnName, COUNT(*) AS row_count
FROM eventsTable
WHERE columnName = 'Business'
GROUP BY columnName

eumiro 2010-10-07 18:36:59

Can't have `where` clause in group by. Use `Having`

Jim 2010-10-07 18:41:27

Unless I am mistaken about what is being asked for, this answer should be what the OP needs.

Mike Cheel 2010-10-07 18:42:29

@Jim - You can use have a `where` clause with `group by`. You would need to use `having` if you wanted to filter on the result of an aggregate when using `group by`.

Barry 2010-10-07 18:43:23

Answer 2

A:

Assuming there is a column named business:

SELECT Business, COUNT(*) FROM eventsTable GROUP BY Business

Noel Abrahams 2010-10-07 18:38:44

Answer 3

+3 A:

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'

Barry 2010-10-07 18:38:54

+1 Over clause is *elegant*

gbn 2010-10-07 18:47:34

Answer 4

+1 A:

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
WHEREe.columnName='Business'

rugg 2010-10-07 18:45:22

ansaurus

tags:

views:

answers:

SQL subquery with COUNT help

related questions