Tag archive
Commands grouped around the same concept, pattern, or recurring problem.
Use `SIGN` to reduce any number to -1, 0, or 1 based on whether it is negative, zero, or positive.
Use `GREATEST` and `LEAST` to compare multiple values in a single expression without a `CASE WHEN` chain.