how to get first value of rows in sql server

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