FIRST()函数返回指定的列中第一个记录的值。
SQL FIRST() 语法
SELECT FIRST(column_name) FROM table_name;
注释:只有MS Access支持FIRST()函数。
SQL Server 语法
SELECT TOP 1 column_name FROM table_name
ORDER BY column_name ASC;
MySQL 语法
SELECT column_name FROM table_name
ORDER BY column_name ASC
LIMIT 1;
Oracle 语法
SELECT column_name FROM table_name
ORDER BY column_name ASC
WHERE ROWNUM <=1;
演示数据库
SQL FIRST() 示例
SELECT name AS FirstSite FROM Websites LIMIT 1;
执行结果:
参考:
https://www.yuque.com/docs/share/4b3ded10-38b8-4d35-b34c-69e4d485f55f