Explain LAST function in SQL Server.

The LAST function displays the last value of the selected column.

Ex :

Select last(EmployeeID) as LastEmployeeID from Employees

This Query will display the last value of “EmployeeID” column, the output will be displayed with the column name “LastEmployeeID”.