+ set enginbehavior в помощь

автор
create cursor pp (id i autoinc, fff c(10))

insert into pp (fff) values ('1')
insert into pp (fff) values ('1')
insert into pp (fff) values ('2')

set enginebehavior 70
select * ;
from pp ;
group by fff

set enginebehavior 90
select * ;
from pp ;
group by fff

select fff, count(*) ;
from pp ;
group by fff