Syntax
------

>

Description
-----------

Greater than operator. Evaluates both SQL expressions and returns 1 if the
left value is greater than the right value and 0 if it is not, or NULL if
either expression is NULL. If the expressions return different data types,
(for instance, a number and a string), performs type conversion.

When used in row comparisons these two queries return the same results:

SELECT (t1.a, t1.b) > (t2.x, t2.y) 
FROM t1 INNER JOIN t2;

SELECT (t1.a > t2.x) OR ((t1.a = t2.x) AND (t1.b > t2.y))
FROM t1 INNER JOIN t2;

Examples
--------

SELECT 2 > 2;
+-------+
| 2 > 2 |
+-------+
|     0 |
+-------+

SELECT 'b' > 'a';
+-----------+
| 'b' > 'a' |
+-----------+
|         1 |
+-----------+

URL: https://mariadb.com/kb/en/greater-than/