LAST() 回傳指定欄位的最後一筆值 (依儲存順序或預設排序),支援度因資料庫而異。
SELECT LAST(column_name) FROM table_name;
+----+------------+------------+----------+
| Id | OrderDate | OrderPrice | Customer |
+----+------------+------------+----------+
| 6 | 2008/10/04 | 100 | Nilsen | <-- 最後一筆
+----+------------+------------+----------+
SELECT LAST(OrderPrice) AS LastOrderPrice FROM Orders;
+----------------+
| LastOrderPrice |
+----------------+
| 100 |
+----------------+
| 資料庫 | 支援 LAST() | 標準替代寫法 |
|---|---|---|
| MS Access | ✅ | - |
| SQL Server | ❌ | SELECT TOP 1 col FROM table ORDER BY id DESC |
| MySQL | ❌ | SELECT col FROM table ORDER BY id DESC LIMIT 1 |
| PostgreSQL | ❌ | SELECT col FROM table ORDER BY id DESC LIMIT 1 |
| Oracle | ❌ | SELECT col FROM table ORDER BY id DESC FETCH FIRST 1 ROW ONLY |
不要依賴 LAST(),永遠明確指定排序依據 (如主鍵 id DESC 或時間 created_at DESC) 以確保結果確定性。