ROUND(value[, decimals])
ANSI-consistent across all 11 dialects: MySQL, MariaDB, Postgres, MSSQL, Oracle, SQLite (math-functions extension, 3.35+), CockroachDB, Redshift, DB2, Snowflake, and ClickHouse all accept an optional second decimals argument with the same semantics.
decimals
Optional
ROUND(value[, decimals])ANSI-consistent across all 11 dialects: MySQL, MariaDB, Postgres, MSSQL, Oracle, SQLite (math-functions extension, 3.35+), CockroachDB, Redshift, DB2, Snowflake, and ClickHouse all accept an optional second
decimalsargument with the same semantics.