Important
The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.
In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.
SQL Reference
In this section
- SQL Command Syntax
- SQL Commands List
- SQL Functions List
- Comparison Operators and Functions
- Database Object Case-Sensitivity
- Data Types
- Character Encoding
- Operations that Take Either a Database or a Cluster Level Lock
- User-Defined Variables
- Restricted Keywords
- Aggregate Functions
- BSON Functions
- Cluster Management Commands
- Code Generation Functions
- Conditional Functions
- Data Definition Language DDL
- Data Manipulation Language DML
- Date and Time Functions
- Distinct Count Estimation Functions
- Full-Text Search Functions
- Geospatial Functions
- Identifier Generation Functions
- Information Functions
- JSON Functions
- Numeric Functions
- Operational Commands
- Pipelines Commands
- Procedural SQL Reference
- Regular Expression Functions
- Resource Pool Commands
- Security Management Commands
- SHOW Commands
- String Functions
- Time Series Functions
- Trace Event Commands
- Vector Functions
- Window Functions
Last modified: