![]() GREATEST supports all types, including VARIANT. Returns the largest value from a list of expressions. Note that this is different from the EQUAL comparison operator (=), which treats NULLs as unknown values. The function is NULL-safe, meaning it treats NULLs as known values for comparing equality. ![]() default: If an optional default is specified, and if none of the search expressions match the select expression, then DECODE returns this default value.Ĭompares whether two expressions are equal. ![]() result2: The results are the values that will be returned if one of the search expressions matches the select expression.If more than one search expression would match, only the first match's result is returned. If one of these search expressions matches, the function returns the corresponding result. search2: The search expressions indicate the values to compare to the select expression.result1: The results are the values that will be returned if one of the search expressions matches the select expression.search1: The search expressions indicate the values to compare to the select expression.The select expression is typically a column, but can be a subquery, literal, or other expression. The "search expressions" are compared to this select expression, and if there is a match then DECODE returns the result that corresponds to that search expression. expr: This is the "select expression".As soon as a search expression matches the selection expression, the corresponding result expression is returned. expr1: Returns the first non-NULL expression among its arguments, or NULL if all its arguments are NULL.ĭECODE(expr, search1, result1 )Ĭompares the select expression to each search expression in order.Returns the first non-NULL expression among its arguments, or NULL if all its arguments are NULL. In accordance with Boolean semantics: Non-zero values (including negative numbers) are regarded as True. one of the expressions, but not both expressions, is TRUE). Zero values are regarded as False.Ĭomputes the Boolean XOR of two numeric expressions (i.e. Zero values are regarded as False.Ĭomputes the Boolean OR of two numeric expressions. ![]() Zero values are regarded as False.Ĭomputes the Boolean NOT of a single numeric expression. Non-zero values (including negative numbers) are regarded as True. Shift the bits for a numeric expression n positions to the right, with sign extension.īitwise XOR of two numeric expressions (a and b).Ĭomputes the Boolean AND of two numeric expressions. Shift the bits for a numeric expression n positions to the left.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |