Getting started
User guides
Administration guides
Reference guides
Resources
Updated Aug 11, 2022
Send us feedback
>
Returns true if expr1 is greater than expr2, or false otherwise.
true
expr1
expr2
false
expr1 > expr2
expr1: An expression of any comparable type.
expr2: An expression sharing a least common type with expr1.
A BOOLEAN.
> SELECT 2 > 1; true > SELECT 2 > '1.1'; true > SELECT to_date('2009-07-30 04:17:52') > to_date('2009-07-30 04:17:52'); false > SELECT to_date('2009-07-30 04:17:52') > to_date('2009-08-01 04:17:52'); false > SELECT 1 > NULL; NULL
!= (bangeq sign) operator
<= (lt eq sign) operator
< (lt sign) operator
>= (gt eq sign) operator
<=> (lt eq gt sign) operator
= (eq sign) operator
<> (lt gt sign) operator
SQL data type rules