CrateDB Logo
  • Product
    • Features
    • Architecture
    • Query examples
    • Integrations
    • Pricing
    • Deploy now
  • Solutions
    • Internet of Things
    • Time-series
    • Log analysis
    • Geospatial data
    • Application backend
    • AI/ML
    • Digital twins
  • Customers
  • Developers
    • Community
    • Events
    • GitHub
    • Blog
    • Support
    • Social channels
  • Documentation
  • Login
  • Get CrateDB
Toggle Doc Menu
Search
    • CrateDB Cloud
    • Self-Managed
    • Getting Started
    • Reference Manual
      • 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
    • Admin UI
    • Crash CLI
    • Drivers and Integrations
    • Support
    • Community
    • Integration Tutorials
    • Sample Applications
  Feedback

  Suggest improvement

  Edit page

  View page source

5.4

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

Subscribe to the CrateDB Newsletter now

CrateDB Logo
  • Imprint
  • Contact
  • Legal
Follow us
Follow us on Twitter Follow us on LinkedIn Follow us on Facebook Follow us on Instagram Follow us on Facebook