Contents Menu Expand Light mode Dark mode Skip to content
  • Login
  • Get Started
  • Overview
    • Getting Started

        • Build

      • Load data into CrateDB
        • Connect / Drivers
          • Integrations
            • All Features

                • Operations

              • Installation
                • Administration
                  • Performance guides

                      • References

                    • CrateDB Cloud
                      • CrateDB
                        • Concepts
                          • Joins
                          • Clustering
                          • Storage and consistency
                          • Resiliency
                        • CLI tools
                        • Configuration
                          • Node-specific settings
                          • Cluster-wide settings
                          • Session settings
                          • Logging
                          • Environment variables
                        • General use
                          • Data definition
                            • Creating tables
                            • Data types
                            • System columns
                            • Generated columns
                            • Constraints
                            • Storage
                            • Partitioned tables
                            • Sharding
                            • Replication
                            • Shard allocation filtering
                            • Column policy
                            • Fulltext indices
                            • Fulltext analyzers
                            • Show Create Table
                            • Views
                            • Altering tables
                          • Data manipulation
                          • Querying
                            • Selecting data
                            • Joins
                            • Union
                            • Refresh
                            • Fulltext search
                            • Geo search
                          • Built-in functions and operators
                            • Scalar functions
                            • Aggregation
                            • Arithmetic operators
                            • Table functions
                            • Comparison operators
                            • Array comparisons
                            • Subquery expressions
                            • Window functions
                          • User-defined functions
                          • Blobs
                          • Optimistic Concurrency Control
                          • Information schema
                        • Administration
                          • System information
                          • Runtime configuration
                          • User management
                          • Privileges
                          • Authentication
                            • Authentication Methods
                            • Host-Based Authentication (HBA)
                          • Secured communications (SSL/TLS)
                          • Optimization
                          • Jobs management
                          • JMX monitoring
                          • Snapshots
                          • Logical replication
                          • Cloud discovery
                          • Usage Data Collector
                        • SQL syntax
                          • General SQL
                            • Constraints
                            • Value expressions
                            • Lexical structure
                          • SQL Statements
                            • ALTER CLUSTER
                            • ALTER PUBLICATION
                            • ALTER TABLE
                            • ALTER USER
                            • ANALYZE
                            • BEGIN
                            • START TRANSACTION
                            • COMMIT
                            • COPY FROM
                            • COPY TO
                            • CREATE ANALYZER
                            • CREATE BLOB TABLE
                            • CREATE FUNCTION
                            • CREATE PUBLICATION
                            • CREATE REPOSITORY
                            • CREATE SNAPSHOT
                            • CREATE SUBSCRIPTION
                            • CREATE TABLE
                            • CREATE TABLE AS
                            • CREATE USER
                            • CREATE VIEW
                            • DEALLOCATE
                            • DELETE
                            • DENY
                            • DISCARD
                            • DROP ANALYZER
                            • DROP FUNCTION
                            • DROP PUBLICATION
                            • DROP REPOSITORY
                            • DROP SNAPSHOT
                            • DROP SUBSCRIPTION
                            • DROP TABLE
                            • DROP USER
                            • DROP VIEW
                            • END
                            • EXPLAIN
                            • GRANT
                            • INSERT
                            • KILL
                            • OPTIMIZE
                            • REFRESH
                            • RESTORE SNAPSHOT
                            • REVOKE
                            • SELECT
                            • SET and RESET
                            • SET LICENSE
                            • SET AND RESET SESSION AUTHORIZATION
                            • SET TRANSACTION
                            • SHOW COLUMNS
                            • SHOW CREATE TABLE
                            • SHOW SCHEMAS
                            • SHOW TABLES
                            • SHOW (session settings)
                            • UPDATE
                            • VALUES
                        • Client interfaces
                          • HTTP endpoint
                          • PostgreSQL wire protocol
                        • Appendices
                          • Release Notes
                            • Unreleased Changes
                            • Version 4.8.4
                            • Version 4.8.3
                            • Version 4.8.2
                            • Version 4.8.1
                            • Version 4.8.0
                            • Version 4.7.3
                            • Version 4.7.2
                            • Version 4.7.1
                            • Version 4.7.0
                            • Version 4.6.8
                            • Version 4.6.7
                            • Version 4.6.6
                            • Version 4.6.5
                            • Version 4.6.4
                            • Version 4.6.3
                            • Version 4.6.2
                            • Version 4.6.1
                            • Version 4.6.0
                            • Version 4.5.5
                            • Version 4.5.4
                            • Version 4.5.3
                            • Version 4.5.2
                            • Version 4.5.1
                            • Version 4.5.0
                            • Version 4.4.3
                            • Version 4.4.2
                            • Version 4.4.1
                            • Version 4.4.0
                            • Version 4.3.4
                            • Version 4.3.3
                            • Version 4.3.2
                            • Version 4.3.1
                            • Version 4.3.0
                            • Version 4.2.7
                            • Version 4.2.6
                            • Version 4.2.5
                            • Version 4.2.4
                            • Version 4.2.3
                            • Version 4.2.2
                            • Version 4.2.1
                            • Version 4.2.0
                            • Version 4.1.8
                            • Version 4.1.7
                            • Version 4.1.6
                            • Version 4.1.5
                            • Version 4.1.4
                            • Version 4.1.3
                            • Version 4.1.2
                            • Version 4.1.1
                            • Version 4.1.0
                            • Version 4.0.12
                            • Version 4.0.11
                            • Version 4.0.10
                            • Version 4.0.9
                            • Version 4.0.8
                            • Version 4.0.7
                            • Version 4.0.6
                            • Version 4.0.5
                            • Version 4.0.4
                            • Version 4.0.3
                            • Version 4.0.2
                            • Version 4.0.1
                            • Version 4.0.0
                            • Version 3.3.6
                            • Version 3.3.5
                            • Version 3.3.4
                            • Version 3.3.3
                            • Version 3.3.2
                            • Version 3.3.1
                            • Version 3.3.0
                            • Version 3.2.8
                            • Version 3.2.7
                            • Version 3.2.6
                            • Version 3.2.5
                            • Version 3.2.4
                            • Version 3.2.3
                            • Version 3.2.2
                            • Version 3.2.1
                            • Version 3.2.0
                            • Version 3.1.6
                            • Version 3.1.5
                            • Version 3.1.4
                            • Version 3.1.3
                            • Version 3.1.2
                            • Version 3.1.1
                            • Version 3.1.0
                            • Version 3.0.7
                            • Version 3.0.6
                            • Version 3.0.5
                            • Version 3.0.4
                            • Version 3.0.3
                            • Version 3.0.2
                            • Version 3.0.1
                            • Version 3.0.0
                            • Version 2.3.11
                            • Version 2.3.10
                            • Version 2.3.9
                            • Version 2.3.8
                            • Version 2.3.7
                            • Version 2.3.6
                            • Version 2.3.5
                            • Version 2.3.4
                            • Version 2.3.3
                            • Version 2.3.2
                            • Version 2.3.1
                            • Version 2.3.0
                            • Version 2.2.7
                            • Version 2.2.6
                            • Version 2.2.5
                            • Version 2.2.4
                            • Version 2.2.3
                            • Version 2.2.2
                            • Version 2.2.1
                            • Version 2.2.0
                            • Version 2.1.10
                            • Version 2.1.9
                            • Version 2.1.8
                            • Version 2.1.7
                            • Version 2.1.6
                            • Version 2.1.5
                            • Version 2.1.4
                            • Version 2.1.3
                            • Version 2.1.2
                            • Version 2.1.1
                            • Version 2.1.0
                            • Version 2.0.7
                            • Version 2.0.6
                            • Version 2.0.5
                            • Version 2.0.4
                            • Version 2.0.3
                            • Version 2.0.2
                            • Version 2.0.1
                            • Version 2.0.0
                            • Version 1.2.0
                            • Version 1.1.6
                            • Version 1.1.5
                            • Version 1.1.4
                            • Version 1.1.3
                            • Version 1.1.2
                            • Version 1.1.1
                            • Version 1.1.0
                            • Version 1.0.6
                            • Version 1.0.5
                            • Version 1.0.4
                            • Version 1.0.3
                            • Version 1.0.2
                            • Version 1.0.1
                            • Version 1.0.0
                          • SQL compatibility
                          • SQL standard compliance
                          • Resiliency Issues
                          • Glossary

                        • Tools

                      • Admin UI
                        • CrateDB CLI
                          • Cloud CLI
                            • CrateDB MCP
                            • CrateDB Agent Skills
                            • CrateDB Toolkit
                            • Support
                            • Community

                            General SQLΒΆ

                            Table of contents

                            • Constraints
                            • Value expressions
                            • Lexical structure
                            Next
                            Constraints
                            Previous
                            SQL syntax
                              Feedback

                              Suggest improvement

                              Edit page

                              View page source

                            4.8
                            On this page
                            • General SQL
                            • Imprint
                            • Contact
                            • Legal
                            Follow us
                            Follow us on X Follow us on LinkedIn Follow us on Facebook Follow us on YouTube Follow us on GitHub