Last() Function in sql server

Introduction:

The LAST() function returns the last value of the selected column.

Sysntax:

SELECT LAST(column_name) FROM table_name;

Example: 

SELECT TOP 1 CustomerName FROM Customers
ORDER BY CustomerID DESC;