crate.io Logo
  • Products
    • CrateDB Overview
    • CrateDB Cloud
    • CrateDB Edge
    • CrateDB On-Premises
    • Pricing
    • Get CrateDB
  • Customers
    • Success Stories
    • Use Cases
    • Industries
  • Docs
  • Resources
    • Blog
    • Events
    • Newsletter
    • Videos
    • Webinars
    • White Papers
  • Community
  • Login
  • Get CrateDB
Toggle Doc Menu
Search
    • Install CrateDB
    • CrateDB
    • Reference
      • Concepts
      • CLI tools
      • Configuration
      • General use
        • Data definition
        • Data manipulation
        • Querying
          • Selecting data
          • Joins
          • Union
          • Refresh
          • Fulltext search
          • Geo search
        • Built-in functions and operators
        • User-defined functions
        • Blobs
        • Optimistic Concurrency Control
        • Information schema
      • Administration
      • SQL syntax
      • Client interfaces
      • Appendices
    • Clients and Tools
    • Admin UI
    • Crash CLI
    • CrateDB Cloud
      • Tutorials
      • How-To Guides
      • Reference
      • Croud CLI
    • JDBC
    • PHP DBAL
    • PHP PDO
    • Python
    • .NET Npgsql
    • Sample Applications
    • Support
v:5.2
master latest 5.2 5.1 4.8 3.3

QueryingΒΆ

This section provides an overview of how to query CrateDB.

See also

General use: Data definition

General use: Data manipulation

Table of contents

  • Selecting data
    • Introduction
    • FROM clause
    • Joins
    • DISTINCT clause
    • WHERE clause
    • Comparison operators
    • Array comparisons
    • EXISTS
    • Container data types
    • Aggregation
    • Window functions
    • GROUP BY
    • WITH Queries (Common Table Expressions)
  • Joins
    • Cross joins
    • Inner joins
    • Outer joins
    • Join conditions
    • Available join algorithms
    • Limitations
  • Union
    • Union All
    • Union Distinct
  • Refresh
    • Introduction
    • Multiple Table Refresh
    • Partition Refresh
  • Fulltext search
    • MATCH Predicate
    • Usage
    • Searching On Multiple Columns
    • Negative Search
    • Filter By _score
  • Geo search
    • Introduction
    • MATCH predicate
    • Exact queries

Feedback

How helpful was this page?
New issue Edit on GitHub View on GitHub

Product

  • CrateDB Overview
  • CrateDB Cloud
  • CrateDB Edge
  • CrateDB On-Premises
  • Compare
  • Pricing
  • Download
  • CrateDB Cloud Login

Customers

  • Success Stories
  • Use Cases
  • Industries

Resources

  • Blog
  • Events
  • Content Library
  • Newsletter
  • Videos
  • Webinars
  • White Papers

Developers

  • Get Started
  • Reference
  • How-To Guides
  • Support
  • SQL 99 Docs
  • Community
  • Github
  • Contribute

Company

  • About us
  • Jobs
  • Partners
  • Newsroom
  • Security
  • Contact

Follow us

Follow us on Twitter Follow us on Twitter Follow us on LinkedIn Follow us on LinkedIn Follow us on Facebook Follow us on Facebook Follow us on YouTube Follow us on YouTube Follow us on GitHub Follow us on GitHub
  • Legal
  • Privacy Policy
  • Imprint

erdf
  • Legal
  • Privacy Policy
  • Imprint
  • European Regional Development Funds Logo
crate.io Logo

Subscribe to the Crate.io Newsletter now