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/