|
Posted by --CELKO-- on 09/23/07 23:01
>> I might also watch for a future version of SQL Server to include
RUNNING_TOTAL() OVER(ORDER BY <column(s)>), similar to ROW_NUMBER()
which is effectively a special case of a running total: <<
Nope, not likely. The ANSI/ISO syntax is already there and I hope SQL
Server would use it:
SUM(foobar)
OVER ([ORDER BY ..]
[PARTITION BY ..]
<range clause>)
The <range clause> defines how many preceding or following rows are in
the window (that is the name of the OVER() clause. You have a wide
range of options here. Look it up; DB2 and Oracle have full
implementations.
Navigation:
[Reply to this message]
|