Leyne, Sean wrote:

>> This is not what the new "Table expressions" are for ?
>>
>
> 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.

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.


Adriano