SQL Server Open Window function

SqlServer2005 above provides window sorting and window aggregation functions.

Sort by rank () and row_number () two function window.

The rank () function is arranged identically to produce the same sort, and the next different sort will be skipped, such as generating 1, 1, 3.

The Row_number () function produces a different sort, such as a-to-do, even if arranged identically.

Over () can be sorted only, partition by grouping open windows.

cannot be sorted in open window aggregation.

Select Productno,productname,price,amount,         Over  by Order  by amount) RowNo,       SUM over by Productno) TotalAmount,        MAX  Over  by productno) maxprice from product

SQL Server Open Window function