SQL LAST()
Function
LAST() Function
The LAST() function returns the value of the last record in the specified column.
SQL LAST() Syntax
Note: Only MS Access supports the LAST() function.
SQL LAST() Workaround for SQL Server, MySQL, and Oracle
SQL Server Syntax
Example
MySQL Syntax
Example
Oracle Syntax
Example
Demo Database
In this tutorial, we will use the tutorialpro sample database.
Below is the data from the "Websites" table:
+----+--------------+---------------------------+-------+---------+
| id | name | url | alexa | country |
+----+--------------+---------------------------+-------+---------+
| 1 | Google | https://www.google.cm/ | 1 | USA |
| 2 | Taobao | https://www.taobao.com/ | 13 | CN |
| 3 | tutorialpro.org | http://www.tutorialpro.org/ | 4689 | CN |
| 4 | Weibo | http://weibo.com/ | 20 | CN |
| 5 | Facebook | https://www.facebook.com/ | 3 | USA |
| 6 | Baidu | https://www.baidu.com/ | 4 | CN |
| 7 | Stackoverflow | http://stackoverflow.com/ | 0 | IND |
+----+---------------+---------------------------+-------+---------+
SQL LAST() Example
The following SQL statement selects the value of the last record in the "name" column of the "Websites" table:
Example
The result of the above SQL statement is as follows: