Explain FIRST function in SQL Server.

The FIRST function displays the first value of the selected column.

Ex :

Select first(EmployeeID) as FirstEmployeeID from Employees

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