| 數據庫 | 語法 | 示例 |
|---|---|---|
| MySQL / PostgreSQL / SQLite | LIMIT | SELECT * FROM t WHERE cond ORDER BY id LIMIT 1 |
| Oracle 12c+ | FETCH FIRST | SELECT * FROM t WHERE cond ORDER BY id FETCH FIRST 1 ROW ONLY |
| Oracle 11g | ROWNUM 子查詢 | SELECT * FROM (SELECT * FROM t WHERE cond ORDER BY id) WHERE ROWNUM = 1 |
| SQL Server | TOP | SELECT TOP 1 * FROM t WHERE cond ORDER BY id |
ORDER BY 確定「第一條」語義ROWNUM 在 ORDER BY 前計算，必須用子查詢OFFSET ... LIMIT ... (標準 SQL) 或各自方言
