Prev Next
SQL LAST() function returns the last field value of the given column. LAST() function is supported in MS Access database only. Syntax for SQL LAST() function is given below.
SQL Syntax for LAST() function:
| Syntax for LAST() function in SQL | SELECT LAST(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