Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
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: November 7, 2024