您好,我是小DAI,专注于数据库管理员相关的技术问答,请问有什么可以帮您?

func_sql__function__LAST

SQL LAST() 语法


SELECT LAST(column_name) FROM table_name;

注释:只有 MS Access 支持 LAST() 函数。

SQL Server、MySQL 和 Oracle 中的 SQL LAST() 工作区

SQL Server 语法


SELECT TOP 1 column_name FROM table_name
ORDER BY column_name DESC;

实例


SELECT TOP 1 name FROM Websites
ORDER BY id DESC;

<h4>MySQL 语法</h4>

SELECT column_name FROM table_name

ORDER BY column_name DESC

LIMIT 1;



<h4>实例</h4>

SELECT name FROM Websites

ORDER BY id DESC

LIMIT 1;



<h4>Oracle 语法</h4>

SELECT column_name FROM table_name

ORDER BY column_name DESC

WHERE ROWNUM <=1;



<h4>实例</h4>

SELECT name FROM Websites

ORDER BY id DESC

WHERE ROWNUM <=1;



<h4>演示数据库</h4>

在本教程中,我们将使用 RUNOOB 样本数据库。

下面是选自 "Websites" 表的数据:

+----+--------------+---------------------------+-------+---------+

+----+--------------+---------------------------+-------+---------+

1 Google https://www.google.cm/ 1 USA
3 菜鸟教程 http://www.runoob.com/ 4689 CN
4 微博 http://weibo.com/ 20 CN
5 Facebook https://www.facebook.com/ 3 USA
6 百度 https://www.baidu.com/ 4 CN
7 stackoverflow http://stackoverflow.com/ 0 IND

+----+---------------+---------------------------+-------+---------+


<h3>SQL LAST() 实例</h3>

下面的 SQL 语句选取 "Websites" 表的 "name" 列中最后一个记录的值:

<h4>实例</h4>

SELECT name FROM Websites

ORDER BY id DESC

LIMIT 1;

```

执行以上 SQL 结果如下所示:

![](https://www.runoob.com/wp-content/uploads/2013/09/last1.jpg)

来源:https://www.runoob.com/sql/sql-func-last.html