>How can I summarize a table like this
>
>
> USA
> USA
> USA
> USA
> BRAZIL
> BRAZIL
> BRAZIL
> UK
> UK
> UK
> UK
> UK
> CANADA
> CANADA
>
> ......Etc. Over 2000 names
>
>
> To a new summarized table
>
> USA
> BRAZIL
> UK
> CANADA
> ..........ETC
select distinct CountryName;
from Countries;
into table DistinctCountries
Or:
select CountryName, count(*) as HowOften;
from Countries;
group by CountryName;
into table DistinctCountries
The second field (count(*)...), of course, is optional - you didn't ask for it, and you may want to omit that part.
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
