SQL Functions (Analytic) LAST_VALUE
Example
The LAST_VALUE function provides the last value in an ordered result set, which you specify using a scalar expression.
SELECT TerritoryID, StartDate, BusinessentityID,
LAST_VALUE(BusinessentityID)
OVER(ORDER BY TerritoryID) AS LastValue
FROM SalesTerritoryHistory;
This example uses the LAST_VALUE function to return the last value for each rowset in the ordered values.
| TerritoryID | StartDate | BusinessentityID | LastValue |
|---|---|---|---|
| 1 | 2005-07-01 00.00.00.000 | 280 | 283 |
| 1 | 2006-11-01 00.00.00.000 | 284 | 283 |
| 1 | 2005-07-01 00.00.00.000 | 283 | 283 |
| 2 | 2007-01-01 00.00.00.000 | 277 | 275 |
| 2 | 2005-07-01 00.00.00.000 | 275 | 275 |
| 3 | 2007-01-01 00.00.00.000 | 275 | 277 |
