Adriano,

> > I was thinking the same thing, but they are different. The "Window
> > Functions" define a separate syntax.
> >
> > I suspect that the current functionality for the Common Table
> > Expressions, could be used as the basis for the functions which have
> > been requested.


> I see nothing in common of the two features, except that in SQL2003
> exists a WINDOW syntax that's similar to CTE.

Funny, I saw each WINDOW definition as its own CTE, with join criteria
to the main SELECT.

> The window functions (aka analytic functions) is a way to return GROUP
> BY information withing all the rows of the queries (without the group

by).

>
> For example, you can return a sum of _value_ in one column and _value_
> in another one.

In general, I agree. The full syntax, however, is much more than that.


Sean