Contents Menu Expand Light mode Dark mode Skip to content

Crate.io AG Brings CrateDB Back to Europe and Partners with STACKIT for a Fully European Stack

Read the Announcement
  • Product
    • Editions
      • CrateDB Cloud
      • CrateDB Enterprise
      • CrateDB OSS
    • Features
      • Overview
      • High cardinality
      • SQL syntax
      • Integrations
      • Security
    • Data models
      • Time-series
      • Document/JSON
      • Vector
      • Full-text
      • Spatial
      • Relational
  • Solutions
    • By use cases | Real-time
      • Industrial Analytics
      • AI operations
      • Application analytics
    • By industry
      • Manufacturing
      • Energy
      • FMCG
      • Logistics
      • Oil, Gas & Mining
      • Transportation
      • SaaS
      • Media & Entertainment
  • Resources
    • Customer stories
    • Academy
    • Asset library
    • Blog
    • Events
  • Developer
    • Documentation
    • Drivers and tools
    • Community
    • GitHub
    • Support
  • Pricing
  • 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
                            • Bit 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
                          • Users and roles management
                          • Privileges
                          • Authentication
                            • Authentication Methods
                            • Host-Based Authentication (HBA)
                          • Secured communications (SSL/TLS)
                          • Optimization
                          • Jobs management
                          • JMX monitoring
                          • Snapshots
                          • Foreign Data Wrappers
                          • Logical replication
                          • Cloud discovery
                          • Usage Data Collector
                        • SQL syntax
                          • General SQL
                            • Constraints
                            • Value expressions
                            • Lexical structure
                          • SQL Statements
                            • ALTER CLUSTER
                            • ALTER PUBLICATION
                            • ALTER REPOSITORY
                            • ALTER ROLE
                            • ALTER SERVER
                            • ALTER TABLE
                            • ALTER USER
                            • ANALYZE
                            • BEGIN
                            • CLOSE
                            • COMMIT
                            • COPY FROM
                            • COPY TO
                            • CREATE ANALYZER
                            • CREATE BLOB TABLE
                            • CREATE FOREIGN TABLE
                            • CREATE FUNCTION
                            • CREATE PUBLICATION
                            • CREATE REPOSITORY
                            • CREATE ROLE
                            • CREATE SCHEMA
                            • CREATE SERVER
                            • CREATE SNAPSHOT
                            • CREATE SUBSCRIPTION
                            • CREATE TABLE
                            • CREATE TABLE AS
                            • CREATE TABLE LIKE
                            • CREATE USER
                            • CREATE USER MAPPING
                            • CREATE VIEW
                            • DEALLOCATE
                            • DECLARE
                            • DELETE
                            • DENY
                            • DISCARD
                            • DROP ANALYZER
                            • DROP FOREIGN TABLE
                            • DROP FUNCTION
                            • DROP PUBLICATION
                            • DROP REPOSITORY
                            • DROP ROLE
                            • DROP SCHEMA
                            • DROP SERVER
                            • DROP SNAPSHOT
                            • DROP SUBSCRIPTION
                            • DROP TABLE
                            • DROP USER
                            • DROP USER MAPPING
                            • DROP VIEW
                            • END
                            • EXPLAIN
                            • FETCH
                            • GRANT
                            • INSERT
                            • KILL
                            • OPTIMIZE
                            • REFRESH
                            • RESTORE SNAPSHOT
                            • REVOKE
                            • SELECT
                            • SET and RESET
                            • SET AND RESET SESSION AUTHORIZATION
                            • SET TRANSACTION
                            • SHOW (session settings)
                            • SHOW COLUMNS
                            • SHOW CREATE TABLE
                            • SHOW SCHEMAS
                            • SHOW TABLES
                            • START TRANSACTION
                            • UPDATE
                            • VALUES
                            • WITH
                        • Client interfaces
                          • HTTP endpoint
                          • PostgreSQL wire protocol
                        • Appendices
                          • Release Notes
                            • Version 6.4.7 - Unreleased
                            • Version 6.4.6
                            • Version 6.4.5
                            • Version 6.4.4
                            • Version 6.4.3
                            • Version 6.4.2
                            • Version 6.4.1
                            • Version 6.4.0
                            • Version 6.3.7
                            • Version 6.3.6
                            • Version 6.3.5
                            • Version 6.3.4
                            • Version 6.3.3
                            • Version 6.3.2
                            • Version 6.3.1
                            • Version 6.3.0
                            • Version 6.2.11
                            • Version 6.2.10
                            • Version 6.2.9
                            • Version 6.2.8
                            • Version 6.2.7
                            • Version 6.2.6
                            • Version 6.2.5
                            • Version 6.2.4
                            • Version 6.2.3
                            • Version 6.2.2
                            • Version 6.2.1
                            • Version 6.2.0
                            • Version 6.1.6
                            • Version 6.1.5
                            • Version 6.1.4
                            • Version 6.1.3
                            • Version 6.1.2
                            • Version 6.1.1
                            • Version 6.1.0
                            • Version 6.0.8
                            • Version 6.0.7
                            • Version 6.0.6
                            • Version 6.0.5
                            • Version 6.0.4
                            • Version 6.0.3
                            • Version 6.0.2
                            • Version 6.0.1
                            • Version 6.0.0
                            • Version 5.10.16
                            • Version 5.10.15
                            • Version 5.10.14
                            • Version 5.10.13
                            • Version 5.10.12
                            • Version 5.10.11
                            • Version 5.10.10
                            • Version 5.10.9
                            • Version 5.10.8
                            • Version 5.10.7
                            • Version 5.10.6
                            • Version 5.10.5
                            • Version 5.10.4
                            • Version 5.10.3
                            • Version 5.10.2
                            • Version 5.10.1
                            • Version 5.10.0
                            • Version 5.9.13
                            • Version 5.9.12
                            • Version 5.9.11
                            • Version 5.9.10
                            • Version 5.9.9
                            • Version 5.9.8
                            • Version 5.9.7
                            • Version 5.9.6
                            • Version 5.9.5
                            • Version 5.9.4
                            • Version 5.9.3
                            • Version 5.9.2
                            • Version 5.9.1
                            • Version 5.9.0
                            • Version 5.8.8 - Unreleased
                            • Version 5.8.7
                            • Version 5.8.6
                            • Version 5.8.5
                            • Version 5.8.4
                            • Version 5.8.3
                            • Version 5.8.2
                            • Version 5.8.1
                            • Version 5.8.0
                            • Version 5.7.6
                            • Version 5.7.5
                            • Version 5.7.4
                            • Version 5.7.3
                            • Version 5.7.2
                            • Version 5.7.1
                            • Version 5.7.0
                            • Version 5.6.5
                            • Version 5.6.4
                            • Version 5.6.3
                            • Version 5.6.2
                            • Version 5.6.1
                            • Version 5.6.0
                            • Version 5.5.5 - Not released
                            • Version 5.5.4
                            • Version 5.5.3
                            • Version 5.5.2
                            • Version 5.5.1
                            • Version 5.5.0
                            • Version 5.4.8
                            • Version 5.4.7
                            • Version 5.4.6
                            • Version 5.4.5
                            • Version 5.4.4
                            • Version 5.4.3
                            • Version 5.4.2
                            • Version 5.4.1
                            • Version 5.4.0
                            • Version 5.3.9
                            • Version 5.3.8
                            • Version 5.3.7
                            • Version 5.3.6
                            • Version 5.3.5
                            • Version 5.3.4
                            • Version 5.3.3
                            • Version 5.3.2
                            • Version 5.3.1
                            • Version 5.3.0
                            • Version 5.2.11
                            • Version 5.2.10
                            • Version 5.2.9
                            • Version 5.2.8
                            • Version 5.2.7
                            • Version 5.2.6
                            • Version 5.2.5
                            • Version 5.2.4
                            • Version 5.2.3
                            • Version 5.2.2
                            • Version 5.2.1
                            • Version 5.2.0
                            • Version 5.1.4
                            • Version 5.1.3
                            • Version 5.1.2
                            • Version 5.1.1
                            • Version 5.1.0
                            • Version 5.0.3
                            • Version 5.0.2
                            • Version 5.0.1
                            • Version 5.0.0
                            • 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 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

                            latest
                            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 Instagram Follow us on Facebook