📄️ ASSUME_NOT_NULL
Results in an equivalent non-Nullable value for a Nullable type. In case the original value is NULL the result is undetermined.
📄️ COALESCE
Checks from left to right whether NULL arguments were passed and returns the first non-NULL argument.
📄️ EXISTS
The exists condition is used in combination with a subquery and is considered "to be met" if the subquery returns at least one row.
📄️ GENERATE_SERIES
Generates a dataset starting from a specified point, ending at another specified point, and optionally with an incrementing value. The GENERATE_SERIES function works with the following data types:
📄️ GROUPING
Returns a bit mask indicating which GROUP BY expressions are not included in the current grouping set. Bits are assigned with the rightmost argument corresponding to the least-significant bit; each bit is 0 if the corresponding expression is included in the grouping criteria of the grouping set generating the current result row, and 1 if it is not included.
📄️ HUMANIZE_NUMBER
Returns a readable number.
📄️ HUMANIZE_SIZE
Returns the readable size with a suffix(KiB, MiB, etc).
📄️ IGNORE
By using insert ignore statement, the rows with invalid data that cause the error are ignored and the rows with valid data are inserted into the table.
📄️ TO_NULLABLE
Converts a value to its nullable equivalent.
📄️ TYPEOF
TYPEOF function is used to return the name of a data type.