GreaterThanOrEqual() function

The GreaterThanOrEqual() function compares two nodes to determine if the first is greater or equal to the second. Implements the comparison operator and can be used in SQL statements either using the function name or the corresponding symbol.

Returns: Boolean

Syntax

GreaterThanOrEqual(node1, node2)
node1
The node that you are will compare against.
node2
The node that you are checking to see if it is greater than or equal to node1.

Examples

Example 1
SELECT *
FROM tablename
WHERE GreaterThanOrEqual(nodecolumn, “1.4”);
Example 2
SELECT *
FROM tablename
WHERE nodecolumn >= “1.4”;

This example is the same as Example 1, except a greater than or equal sign is used in place of the function name.


Copyright© 2019 HCL Technologies Limited