LAST VALUE

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|