>
Syntax
>
Contents
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 | +-----------+
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.