November 2008
Intermediate to advanced
591 pages
17h 28m
English
SQL Server’s window function syntax is as follows:
FUNCTION_NAME(expr) OVER ([window_clause])window_clause::= [partitioning] [ordering]partitioning::= PARTITION BYvalue[,value...]ordering::= ORDER BYrule[,rule...]rule::=column[ASC | DESC]