Subject Re: [firebird-support] Fb/1.5 loop(?)
Author Gary Benade
> I don't think your suggestion will work. What will "count(*)" count, and
> what is there to GROUP BY?

Count(*) will count the unique unstances of LAND, and it will grouop by
land.

So if land has

AFRICA
AFRICA
AMERICA

it will return

AFRICA 2
AMERICA 1

Regards
Gary