Can I "GROUP BY" a partial field value in Access/SQL?

Question

In Access/SQL, I know I can GROUP BY ,say, country or age.

Can I also GROUP BY partial value, for example, field start with something like "G" or "18", so that "Germany" and "Ghana" are in one group, "1897" and "1870" are in one group?

Answer 1

You can group by any non-aggregate expression. E.g.:

SELECT   LEFT(country, 1), COUNT(*)
FROM     mytable
GROUP BY LEFT(country, 1)