A select like this will return all the uniques values of NoMember:
SELECT Client.NoMember
FROM Client
WHERE Client.Active=1
GROUP BY Client.NoMember
Now, let's assume the goal is to obtain the count.
The following would not work:
SELECT COUNT(*) AS RecordCount
FROM Client
WHERE Client.Active=1
GROUP BY Client.NoMember
...as it will return all records related to the group and that the GROUP BY itself.
In my example, I have 19 records for the same member. So, the first select returns one record saying that Client.NoMember found is 1. The second select returns a count of 19.
What would be the best approach to count over the group by? Basically, I would like to obtain 1 as all those 19 records are from the same member.