Gary Benade wrote:

>>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.

In fact, your suggestion works.
select LAND || ' ' || count(*) || ' '
from TITLER
group by LAND
order by count(*) desc
But the result is about as ugly as my first attempt ...

My immediate reaction was that making the result into one single
(concatenated) field would "fool" the count(*) - I was wrong :-|


Thanks,
Aage J.