> (greater than)

The greater than operator (>) returns a boolean value indicating whether the value of the first argument is greater than the value of the second.

Syntax

X>Y

Input

Argument Type Description
X any simple type A scalar expression or column expression
Y any simple type A scalar expression or column expression

Return Value

Returns a boolean value of 1 or 0 indicating whether or not X is greater than Y.

The data type of the result is integer.

If X is N/A, the result is 0; otherwise, if Y is N/A the result is 1. (N/A is treated as if it were less than any other value.)