5,332
edits
SQL: Difference between revisions
→Common functions
(Created page with "SQL basics ==Common functions== See [https://www.postgresql.org/docs/16/functions-math.html Postgres math functions] and [https://www.postgresql.org/docs/current/functions-conditional.html Postgres conditional functions]. * Average * Sum * Round * [https://www.postgresql.org/docs/current/functions-conditional.html#FUNCTIONS-COALESCE-NVL-IFNULL Coalesce] - return the first non-null parameter. * [https://www.postgresql.org/docs/current/functions-conditional.html#FUNCTIO...") |
|||
| Line 3: | Line 3: | ||
==Common functions== | ==Common functions== | ||
See [https://www.postgresql.org/docs/16/functions-math.html Postgres math functions] | ===Math functions=== | ||
See [https://www.postgresql.org/docs/16/functions-math.html Postgres math functions] | |||
* Average | * Average | ||
* Sum | * Sum | ||
* Round | * Round | ||
===Conditional functions=== | |||
See [https://www.postgresql.org/docs/current/functions-conditional.html Postgres conditional functions]. | |||
* [https://www.postgresql.org/docs/current/functions-conditional.html#FUNCTIONS-COALESCE-NVL-IFNULL Coalesce] - return the first non-null parameter. | * [https://www.postgresql.org/docs/current/functions-conditional.html#FUNCTIONS-COALESCE-NVL-IFNULL Coalesce] - return the first non-null parameter. | ||
* [https://www.postgresql.org/docs/current/functions-conditional.html#FUNCTIONS-CASE Case] | * [https://www.postgresql.org/docs/current/functions-conditional.html#FUNCTIONS-CASE Case] | ||