The FIRST function returns the value of the first record in the specified field.
使用FIERST函数可以将指定区域内的第一条记录值返回出来。

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

语法

SELECT FIRST(column) AS [expression]
FROM table

举例

SELECT FIRST(Age) AS lowest_age
FROM Persons
ORDER BY Age

结果:

19

评论 (0) All