聚合函数:取最后一条数据
MySQL LAST()
函数返回指定列的最后一个值。
语法:
SELECT column_name
FROM table_name
ORDER BY column_name DESC
LIMIT 1;
MySQL Last() 函数实例
考虑 "officers"
表,有如下数据。
执行下面查询语句:
SELECT officer_name
FROM officers
ORDER BY officer_id DESC
LIMIT 1;
该查询将会返回最后一个 officer_name
的值, 通过降序 officer_id
输出:
返回最后一个 officer_name
的值按 officer_name
降序 :
SELECT officer_name
FROM officers
ORDER BY officer_name DESC
LIMIT 1;
输出:
推荐文章: