SQL Reference

This SQL Reference section includes details about the different data types, functions, and operators available when writing queries for . For an introduction to the general query syntax and working with queries in Ocient, see Query Ocient﻿.
For information on the SQL syntax conventions used throughout the Ocient documentation, see the SQL Syntax Conventions﻿ page. 
Data Types
﻿Data Types﻿ 
Functions & Operators
﻿Aggregate Functions﻿ 
﻿Sorted Aggregate Functions﻿ 
﻿Window Aggregate Functions﻿ 
﻿Table-Valued Functions﻿ 
﻿Scalar Data Conversion Functions﻿ 
﻿Date / Time Functions﻿﻿
﻿Time Zone Functions﻿  
﻿Formatting Functions﻿ 
﻿Math Functions﻿ 
﻿Arithmetic Operations Supported﻿ 
﻿Character / Binary Functions﻿ 
﻿SIMILAR TO Operator﻿ 
﻿Matrix Functions and Operators﻿ 
﻿Tuple Functions and Operators﻿ 
﻿Other Functions and Expressions﻿ 
﻿Array Functions and Operators﻿ 
Geospatial Functions & Operators
﻿Attribute Functions﻿  
﻿Conversion Functions﻿ 
﻿Linestring Functions﻿ 
﻿Linestring Constructors﻿ 
﻿Point Constructors﻿ 
﻿Polygon Constructors﻿ 
﻿Spatial Measurement﻿ 
﻿Spatial Operators﻿ 
﻿Spatial Relationships﻿ 
﻿Spatiotemporal Measurement﻿ 
﻿Spatiotemporal Operators﻿ 
DDL Commands
﻿Cluster and Node Management﻿ 
﻿Database, Tables, Views, and Indexes﻿ 
﻿Rebuild Tasks and Check Data﻿ 
﻿Users, Groups, and Service Classes﻿ 
﻿Data Integrity and Storage﻿ 
﻿Query Analysis﻿ 
DCL Commands
﻿Data Control Language (DCL) Command Reference﻿ 
Machine Learning Execution
﻿Machine Learning Model Functions﻿ 
Other SQL Reference
﻿Errors and Warnings﻿ 
﻿Reserved Words﻿﻿
﻿
Updated 31 Oct 2023
Did this page help you?
Ocient Simulator
Aggregate Functions