SQL 方言參考/函式和表示式/數學函式/三角函式
< SQL 方言參考
| SQL 版本 | 功能 | 標準 SQL:2011 |
DB2 | Firebird | Ingres | Linter | MSSQL | MySQL 版本 5.x |
MonetDB | Oracle 版本 11.x |
PostgreSQL | SQLite | Virtuoso |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ? | 反正弦 | N/A | ASIN(x) | ASIN(x) | ASIN(X) | ASIN(x) | ASIN(x) | ASIN(x) | ASIN(x) | ASIN(x) | ASIN(x) | N/A | ASIN(x) |
| ? | 反餘弦 | N/A | ACOS(x) | ACOS(x) | ACOS(x) | ACOS(x) | ACOS(x) | ACOS(x) | ACOS(x) | ACOS(x) | ACOS(x) | N/A | ACOS(x) |
| ? | x 的反正切 | N/A | ATAN(x) | ATAN(x) | ATAN(x) | ATAN(x) | ATAN(x) | ATAN(x) | ATAN(x) | ATAN(x) | ATAN(x) | N/A | ATAN(x) |
| ? | x 和 y 的反正切 | N/A | ATAN2(x, y) | ATAN2(x,y) | ATAN2(x, y) | ATAN2(x, y) | ATN2(x, y) | ATAN2(x, y) ATAN(x, y) |
ATAN2(x,y) | ATAN2(x, y) ATAN2(x / y) |
ATAN2(x,y) | N/A | ATAN2(x, y) |
| ? | 正弦 | N/A | SIN(x) | SIN(x) | SIN(x) | SIN(x) | SIN(x) | SIN(x) | SIN(x) | SIN(x) | SIN(x) | N/A | SIN(x) |
| ? | 餘弦 | N/A | COS(x) | COS(x) | COS(x) | COS(x) | COS(x) | COS(x) | COS(x) | COS(x) | COS(x) | N/A | COS(x) |
| ? | 正切 | N/A | TAN(x) | TAN(x) | TAN(x) | TAN(x) | TAN(x) | TAN(x) | TAN(x) | TAN(x) | TAN(x) | N/A | TAN(x) |
| ? | 餘切 | N/A | COT(x) | COT(x) | N/A | N/A | COT(x) | COT(x) | COT(x) | N/A | COT(x) | N/A | COT(x) |
| ? | 雙曲正弦 | N/A | SINH(x) | SINH(x) | N/A | SINH(x) | N/A | N/A | SINH(x) | SINH(x) | N/A | N/A | N/A |
| ? | 雙曲餘弦 | N/A | COSH(x) | COSH(x) | N/A | COSH(x) | N/A | N/A | COSH(x) | COSH(x) | N/A | N/A | N/A |
| ? | 雙曲正切 | N/A | TANH(x) | TANH(x) | N/A | TANH(x) | N/A | N/A | TANH(x) | TANH(x) | N/A | N/A | N/A |
| ? | 雙曲反正切 | N/A | ATANH(x) | ATANH(x) | N/A | ? | N/A | N/A | N/A | N/A | N/A | N/A | ? |