Help Center > > Developer Guide> SQL Reference> Functions and Operators> Comparison Operators

Comparison Operators

Updated at:Aug 27, 2020 GMT+08:00

Comparison operators are available for all data types and return Boolean values.

All comparison operators are binary operators. Only data types that are the same or can be implicitly converted can be compared using comparison operators.

Table 1 describes comparison operators provided by GaussDB(DWS).

Table 1 Comparison Operators




Less than


Greater than


Less than or equal to


Greater than or equal to



<> or !=


Comparison operators are available for all relevant data types. All comparison operators are binary operators that returned values of Boolean type. Expressions like 1 < 2 < 3 are invalid. (Because there is no comparison operator to compare a Boolean value with 3.)

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?

Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel