GreaterThan() function

The GreaterThan( ) function compares two nodes to determine which is greater. This function implements the comparison operator and can be used in SQL statements either using the function name or the corresponding symbol.

Returns: Boolean

Syntax

GreaterThan(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 node1.

Examples

Example 1

SELECT *
FROM tablename
WHERE GreaterThan(nodecolumn, “1.4”);

Example 2

SELECT *
FROM tablename
WHERE nodecolumn > “1.4”;

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