- 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 - Decimal Operator
Query 1
presto:default> select decimal '123' + decimal ’22’ as decimal;
Result
decimal ------- 145
The output is decimal addition.
Query 2
presto:default> select decimal '123' - decimal ’22’ as unary_minus;
Result
unary_minus ------- 101
Query 3
presto:default> select decimal '123' between decimal '100' and decimal '200' as decimal_range;
Result
decimal_range --------------- true
Here, 123 lies between the specified range.
apache_presto_basic_sql_operations.htm
Advertisements
To Continue Learning Please Login
Login with Google