Need Help On How To Do Counts by Uniques

**rsmccli** · Aug 13 '08, 10:14 PM

Originally posted by nanao56

You will want to create a query and use aggregate functions. If you create a query on your table(s) in the graphical query designer, right click in the bottom part and select 'Totals'. Another row of choices will appear. This one's pretty simple, so I would just fool around with the 'Group By' and 'Count' choices. It will be good practice since you are just starting out.

hth,
rsmccli

**nanao56** · Aug 13 '08, 10:29 PM

Originally posted by rsmccli

You will want to create a query and use aggregate functions. If you create a query on your table(s) in the graphical query designer, right click in the bottom part and select 'Totals'. Another row of choices will appear. This one's pretty simple, so I would just fool around with the 'Group By' and 'Count' choices. It will be good practice since you are just starting out.

hth,
rsmccli

Hi! Thanks for replying back.

Any idea on how the SQL would look like?

**nanao56** · Aug 14 '08, 05:41 PM

For the benefit of other users, I got help from someone else. It was simpler than what I thought it was.

Code:

SELECT ProjectName, COUNT(*) As CountOfPeople
FROM (SELECT ProjectName, Person FROM tblTableName GROUP BY ProjectName, Person)
GROUP BY ProjectName

Need Help On How To Do Counts by Uniques

Need Help On How To Do Counts by Uniques

Comment

Comment

Comment