Miscellaneous Functions

This section contains the reference documentation for several Miscellaneous functions built into Splice Machine SQL:

Function Name Description
COALESCE Takes two or more compatible arguments and Returns the first argument that is not null.
NULLIF Returns NULL if the two arguments are equal, and it Returns the first argument if they are not equal.
NVL Takes two or more compatible arguments and Returns the first argument that is not null.
ROWID A pseudocolumn that uniquely defines a single row in a database table.