Hi all,

within other DBs one can use aggregate functions without the group by
clause. This is mostly achieved with the "over( ... )" statement like this
(example is in Oracle):
"select distinct TO_CHAR(RECORD.START_PERIOD-5, 'YYYY'),
avg(RECORD.CALCULATED_VALUE)
over (partition by TO_CHAR(RECORD.START_PERIOD-5, 'YYYY'))
from RECORD
where RECORD.ID = 2".

I haven't found an equivalent for this in the firebird environment looking
at the docs and google. Is there any way to do this with firebird?

Thanks,
Klaus