When you see for the first time these queries, you say :
euh...c'est quoi ca !

Window functions are really useful when you make complex aggregations
for reports and olap.

Alexandre

--- In Firebird-Architect@yahoogroups.com, "Leyne, Sean" <Sean@...>
wrote:

>
> Alexandre,
>
>
> > As far as I know, only Oracle 10g, DB2 9 (and MSSQL partially)

have

> > support for window functions.
> >
> > You could read examples from
> >
> > http://www.oreilly.com/catalog/sqlpg2/chapter/index.html
>
> This link helped a LOT to explain the functions and their purpose.
>
>
> Sean
>