Articles → SQL SERVER → First_Value Function In The SQL Server

First_Value Function In The SQL Server

In this article, we will discuss the First_value function in the SQL server.

Purpose

The First_value function returns the first value of an ordered set of rows in the result set.

Consider the following table: -

Click to Enlarge

To use the function, we will write the following query: -

SELECT
   id,
   [state],
   [Difference],
   FIRST_VALUE([Difference]) OVER (ORDER BY [Difference] ASC) AS [Lowest Difference]
FROM
   population

Query/Feedback