Sign inTry Free
  • Introduction
    • Deploy
      • Connect to Your Cluster
        • Create a Database
          • Integrate with SingleStoreDB
            • Load Data
              • Query Data
                • Manage Data
                  • Developer Resources
                    • User and Cluster Administration
                      • Reference
                        • Configuration Reference
                          • SingleStoreDB Operator Reference
                            • SingleStore Tools Reference
                              • SQL Reference
                                • 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
                                              • 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
                                                                                          • Vector Functions
                                                                                            • Window Functions
                                                                                            • Troubleshooting Reference
                                                                                              • System Databases
                                                                                              • Information Schema Reference
                                                                                                • Data API
                                                                                                  • Code Engine - Powered by Wasm
                                                                                                  • Security
                                                                                                    • Release Notes
                                                                                                      • Support
                                                                                                        • Glossary
                                                                                                        1. Self-Managed v8.0
                                                                                                        2. /
                                                                                                        3. ...
                                                                                                        4. /
                                                                                                        5. SQL Reference

                                                                                                        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
                                                                                                        • 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
                                                                                                        • Vector Functions
                                                                                                        • Window Functions

                                                                                                        Last modified: November 29, 2022

                                                                                                        Was this article helpful?

                                                                                                        SingleStoreDB Studio Log Rotation
                                                                                                        SQL Command Syntax

                                                                                                        Product

                                                                                                        • Product Overview
                                                                                                        • Solutions
                                                                                                        • Pricing
                                                                                                        • Support

                                                                                                        Community

                                                                                                        • Forums
                                                                                                        • Developer Hub
                                                                                                        • Events
                                                                                                        • Training

                                                                                                        Company

                                                                                                        • Contact Us
                                                                                                        • Blog
                                                                                                        • Careers
                                                                                                        • SingleStore Connect

                                                                                                        This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

                                                                                                        • © SingleStore
                                                                                                        • |

                                                                                                        • Privacy Policy
                                                                                                        • |

                                                                                                        • Terms of Service
                                                                                                        • |

                                                                                                        • Legal Terms and Conditions

                                                                                                        Was this article helpful?