Gary Benade wrote:

> Not sure how you want to use the output, but would this not do the job?
>
> select LAND || ' ' || count(*) || ' '
> from TITLER
> group by LAND
> order by count(*) desc

See my answer to Helen.

I don't think your suggestion will work. What will "count(*)" count, and
what is there to GROUP BY?

--
Aage J.