Easy Tutorial
❮ Func Datediff Sql Create Index ❯

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:

❮ Func Datediff Sql Create Index ❯