SQL: Difference between revisions
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..." |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
SQL basics | SQL basics | ||
==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] | ||