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 | ? |