last_value vs first_value in sql server

SQL Server LAST_VALUE function is a Analytic function which returns the Last value in an ordered set of values.