The LAST function returns the value of the last record in the specified field.
使用LAST函数可以将指定区域内的最后一条记录返回出来

Tip: Use the ORDER BY clause to order the records!
提示：可以使用ORDER BY 子句来排列记录！

语法

SELECT LAST(column) AS [expression]
FROM table

举例

SELECT LAST(Age) AS highest_age
FROM Persons
ORDER BY Age

结果:

45

评论 (0) All