This request:

TABLE FILE CAR
SUM CNT.SEATS AS 'COUNT'
BY COUNTRY
BY HIGHEST 1 TOTAL CNT.SEATS NOPRINT
BY CAR
END

Gives this result:

COUNTRY CAR COUNT
--------- ---------- -----
ENGLAND JAGUAR 2
FRANCE PEUGEOT 1
ITALY ALFA ROMEO 3
JAPAN DATSUN 1
TOYOTA 1
W GERMANY BMW 6

Since Japan has two Cars with a Count of 1, it displays two rows. I'd like the request display only one row. Is this possible?

Thanks,

Pietro.

Silly me!

TABLE FILE CAR
SUM CNT.SEATS AS 'COUNT'
BY COUNTRY
BY HIGHEST 1 TOTAL CNT.SEATS NOPRINT
BY LOWEST 1 CAR
END

will do the trick.