First() Function

Introduction:

Returns the first value of the specified expression.

Syntax:

SELECT FIRST(column_name) FROM table_name;

Example:

SELECT TOP 1 CustomerName FROM Customers
ORDER BY CustomerID ASC;