Prev Next
SQL FIRST() function returns the first field value of the given column. FIRST() function is supported in MS Access database only. Syntax for SQL FIRST() function is given below.
SQL Syntax for FIRST() function:
| Syntax for FIRST() function in SQL | SELECT FIRST(column_name) FROM table_name; |
Please consider the following table with few records as given below.
Table name (for example): student
Column names in this table: Student_ID, Student_name, City and Marks
Available records: 4 rows