Hi,

> Is there some way in Firebird to get result set similar like one
> that You get in MS SQL using ROLLUP option, COMPUTE option or
> COMPUTE BY option?

No, there's no build-in way to do this.

You might want to investigate select-able stored procedures
and output an additional row with summarized data whenever
your "group" ends.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com