- Apache Presto Tutorial
- Apache Presto - Home
- Apache Presto - Overview
- Apache Presto - Architecture
- Apache Presto - Installation
- Apache Presto - Configuration
- Apache Presto - Administration
- Apache Presto - SQL Operations
- Apache Presto - SQL Functions
- Apache Presto - MySQL Connector
- Apache Presto - JMX Connector
- Apache Presto - HIVE Connector
- Apache Presto - KAFKA Connector
- Apache Presto - JDBC Interface
- Custom Function Application
- Apache Presto Useful Resources
- Apache Presto - Quick Guide
- Apache Presto - Useful Resources
- Apache Presto - Discussion
Apache Presto - Relational Operator
Relational operators are used to compare between two values. Take a look at the following queries. They show how relational operators work.
Query 1
presto:default> select 4 < 5 as lessthan;
Result
lessthan ---------- true (1 row)
The above condition is true, hence the result is true.
Query 2
presto:default> select 25 >= 45 as greater;
Result
greater --------- false (1 row)
The above condition is false, hence the result is false.
Query 3
presto:default> select 3<>5 as notequal;
Result
notequal ---------- true
Here 3 is not equal to 5, hence the result is returned as true.
apache_presto_basic_sql_operations.htm
Advertisements