LAST_VALUE in SQL Server: Window Function Example

January 15, 2014
| No Comments
SELECT
CustomerID
, SalesOrderID
, CAST(OrderDate AS DATE) AS OrderDate
, TotalDue
, LAST_VALUE(TotalDue) OVER ( PARTITION BY CustomerID ORDER BY SalesOrderID ) AS TD
FROM
Sales.SalesOrderHeader
ORDER BY
CustomerID
SQL Server, T-SQL