Single-row functions operate on a single row. That is, each row’s value is passed to the function with the function returning a single result. The value passed to the function can be based on a pre-existing column’s values (i.e., the individual values within each row), the output or result of another function operating on the column’s values, client and server-side derived values (e.g., current date and time), among other types.
The following subpages are designed to group and address single-row functions based on input or data type.
CHARACTER FUNCTIONS
DATETIME FUNCTIONS
HANDLING MISSING VALUES/NULLS
NUMERIC FUNCTIONS
Keep in mind the single-row functions captured within each of the subpages above is not exhaustive but simply those that I find myself using most frequently. Additionally, a given function may not be available in your current flavor of SQL provided by the RDBMS product you’re using. You can reliably expect for most common RDBMS to provide a function that works identically or similarly with simply a different name or function signature.