SQL 方言參考/函式和表示式/其他表示式
< SQL 方言參考
| SQL 版本 | 功能 | 標準 SQL:2011 |
DB2 | Firebird | Ingres | Linter | MSSQL | MySQL Vers. 5.x |
MonetDB | Oracle Vers. 11.x |
PostgreSQL | SQLite | Virtuoso |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ? | 將值 val 轉換為資料型別 type | CAST(val AS type) | ? | CAST(val AS type) | ? | CAST(val AS type) CASTexpression as type TO_CHAR TO_NUMBER TO_DATE |
CAST(val AS type) CONVERT(type, val, style) |
CONVERT(val, type) CAST(val AS type) |
CAST(val AS type) CONVERT(val, type) |
CAST(val AS type) | CAST(val AS type) val::type |
CAST(val AS type) | ? |
| ? | 用fallback值替換val中的NULL，如果val是非NULL，則返回val | COALESCE(val, fallback) | ? | ? | ? | NVL(val, fallback) | COALESCE(val, fallback) ISNULL(val, fallback) |
IFNULL(val, fallback) | COALESCE(val, fallback) | COALESCE(val, fallback) NVL(val, fallback) |
COALESCE(val, fallback) | IFNULL(val, fallback) COALESCE(val, fallback) |
? |
| ? | 從一系列值（val1, val2, ...）中返回第一個非NULL值 | COALESCE(val1, val2, ...) | COALESCE(val1, val2) | COALESCE(val1, val2, ...) | ? | COALESCE(val1, val2, ...) | COALESCE(val1, val2, ...) | COALESCE(val1, val2, ...) | COALESCE(val1, val2, ...) | COALESCE(val1, val2, ...) | COALESCE(val1, val2, ...) | COALESCE(val1, val2, ...) | ? |
| ? | 將特定值轉換為NULL：如果a = b則返回NULL，否則保留a | NULLIF(a, b) | ? | NULLIF(a, b) | ? | NULLIF(a, b) | NULLIF(a, b) | NULLIF(a, b) | NULLIF(a, b) | NULLIF(a, b) | NULLIF(a, b) | NULLIF(a, b) | ? |