>
(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.)