FIRST Function

SQL FIRST Function

The FIRST function returns the first value of the selected column. FIRST function is not standard SQL function so it cannot be used with other DBMS like MySQL. However this is very useful with MS Access OR SQL Server.

SQL FIRST() Syntax

SELECT FIRST(column_name) FROM Table

Consider the following table for this exercise

Users