SQL LAST()
LAST() Function
LAST() function returns the value of the last record in the specified column.
SQL LAST() syntax
SELECT LAST(column_name) FROM table_name;
Note: Only MS Access supports LAST () function.
SQL LAST() Workspace in SQL Server, MySQL, and Oracle
SQL Server Syntax
SELECT TOP 1 column_nameFROM table_name
ORDER BY column_name DESC;
ORDER BY column_name DESC;
Example
SELECT TOP 1 name FROM Websites
ORDER BY id DESC;
ORDER BY id DESC;
MySQL syntax
SELECT column_name FROM table_name
ORDER BY column_name DESC
LIMIT 1;
ORDER BY column_name DESC
LIMIT 1;
Instance
SELECT name FROM Websites
ORDER BY id DESC
LIMIT 1;
ORDER BY id DESC
LIMIT 1;
Oracle Syntax
SELECT column_name FROM table_name
ORDER BY column_name DESC
WHERE ROWNUM <=1;
ORDER BY column_name DESC
WHERE ROWNUM <=1;
Example
SELECT name FROM Websites
ORDER BY id DESC
WHERE ROWNUM <=1;
ORDER BY id DESC
WHERE ROWNUM <=1;
Demo Database
In this tutorial, we will use the php sample database.
The following is the data selected from the "Websites" table:
+----+--------------+--- ------------------------+------+---------+
| id | name | url --------+-------+---------+
| 1 | Google | https://www.google.cm/ | 1 | USA |
| 2 | Taobao | https://www.taobao.com/ | 13 | CN |
| 3 | php Chinese website | http://www.php.cn/ | 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 |
+----+---- ----------+--------------------------+-------+-- -------+
| id | name | url --------+-------+---------+
| 1 | Google | https://www.google.cm/ | 1 | USA |
| 2 | Taobao | https://www.taobao.com/ | 13 | CN |
| 3 | php Chinese website | http://www.php.cn/ | 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() ExampleThe following SQL statement selects the last record in the "name" column of the "Websites" table Value:
Instance
SELECT name FROM Websites
ORDER BY id DESC
LIMIT 1;
The result of executing the above SQL is as follows:LIMIT 1;
