Opteryx Documentation/Docs

Greater than or equal

Returns true when the left operand is greater than or equal to the right operand.

Category: comparison

SQL symbol: >=

Syntax

sql

<left> >= <right>

Parameters

<left> — The value to compare. Accepts date, decimal, float, integer, interval, nvarchar, timestamp, varbinary, varchar.
<right> — The value to compare it against. Accepts date, decimal, float, integer, interval, nvarchar, timestamp, varbinary, varchar.

Returns

Examples

sql

SELECT name FROM $planets WHERE number_of_moons >= 10;

Jupiter
Saturn
Uranus
Neptune

Signatures

date >= date → boolean
date >= timestamp → boolean
decimal >= decimal → boolean
decimal >= float → boolean
decimal >= integer → boolean
float >= decimal → boolean
float >= float → boolean
float >= integer → boolean
integer >= decimal → boolean
integer >= float → boolean
integer >= integer → boolean
interval >= interval → boolean
nvarchar >= nvarchar → boolean
nvarchar >= varbinary → boolean
nvarchar >= varchar → boolean
timestamp >= date → boolean
timestamp >= timestamp → boolean
varbinary >= nvarchar → boolean
varbinary >= varbinary → boolean
varbinary >= varchar → boolean
varchar >= nvarchar → boolean
varchar >= varbinary → boolean
varchar >= varchar → boolean

Notes

NULL on either side gives NULL, so ordering comparisons never match an absent value.

See Also