SQL FIRST() 函数，LAST() 函数

一.SQL FIRST() 语法

SELECT FIRST(column_name) FROM table_name;     

---

1. SQL Server 语法

SELECT TOP 1 column_name
FROM table_name
ORDER BY column_name ASC;  

2.MySQL 语法

SELECT column_name FROM table_name                
ORDER BY column_name ASC                
LIMIT 1; 

二.SQL LAST() 函数、

SELECT LAST(column_name) FROM table_name;  

1.SQL Server 语法

SELECT TOP 1 column_name
FROM table_name
ORDER BY column_name DESC;  

2.MySQL 语法

SELECT column_name FROM table_name                
ORDER BY column_name DESC                
LIMIT 1;