Posted on 2011-03-08
Hi - I have a number of records with different Analysts assigned in a table and I would like to create a query that returns the record count for each Analyst in the same query but I am not if this can be done. I'm sure it most likely can be but I don't know how to implement it off the top of my head.
For example, I have the query
SELECT count (*) AS JC
WHERE analyst = 'john cashmere'
How can I add more analysts to the query? For example , I have Bill Mosth, Craig Hany, etc etc
It would be great to get all these counts returned in one query
Thanks for any assistance