DuckDB Logo for Download
Documentation
  •   Installation
  •   How-To Guides
  •   Data Import
  •   Client APIs
  •   SQL
  •   Why DuckDB
  •   Media
  •   FAQ
Blog
GitHub
Contributing
  • Installation
  • Guides
    • Data Import & Export
      • CSV Import
      • CSV Export
      • Parquet Import
      • Parquet Export
      • Query Parquet
      • HTTP Parquet Import
      • S3 Parquet Import
      • S3 Parquet Export
      • SQLite Import
      • Postgres Import
    • Meta Queries
      • List Tables
      • Describe
      • Summarize
      • Inspect Query Plan
      • Profile Queries
    • Python
      • Install
      • Execute SQL
      • Jupyter Notebooks
      • SQL on Pandas
      • Import From Pandas
      • Export To Pandas
      • SQL on Arrow
      • Import From Arrow
      • Export To Arrow
      • Relational API on Pandas
      • DuckDB with Ibis
      • DuckDB with Polars
      • DuckDB with Vaex
    • SQL Editors
      • DBeaver SQL IDE
    • Data Viewers
      • Tad
  • Documentation
    • Connect
    • Data Import
      • Overview
      • Insert Statements
      • CSV Files
      • Parquet Files
      • Appender
    • Client APIs
      • Overview
      • Python
        • Overview
        • API Reference
      • R
      • Java
      • Julia
      • C
        • Overview
        • Startup
        • Configure
        • Query
        • Data Chunks
        • Values
        • Types
        • Prepared Statements
        • Appender
        • Table Functions
        • Replacement Scans
        • API Reference
      • C++
      • Node.js
        • Overview
        • API Reference
      • WASM
      • ODBC
        • Overview
        • Linux Setup
        • Windows Setup
      • CLI
    • SQL
      • Introduction
      • Statements
        • Overview
        • Select
        • Insert
        • Delete
        • Update
        • Create Schema
        • Create Table
        • Create View
        • Create Sequence
        • Create Macro
        • Drop
        • Alter Table
        • Copy
        • Export
      • Query Syntax
        • SELECT
        • FROM
        • WHERE
        • GROUP BY
        • GROUPING SETS
        • HAVING
        • ORDER BY
        • LIMIT
        • SAMPLE
        • UNNEST
        • WITH
        • WINDOW
        • QUALIFY
        • VALUES
        • FILTER
        • Set Operations
      • Data Types
        • Overview
        • NULL Values
        • Boolean
        • Enum
        • Numeric
        • Text
        • Date
        • Timestamp
        • Interval
        • Blob
        • List
        • Struct
        • Map
        • Union
      • Expressions
        • Overview
        • Logical
        • Comparisons
        • Casting
        • Case
        • In
        • Star
        • Collations
        • Subqueries
      • Functions
        • Overview
        • Enum Functions
        • Numeric Functions
        • Text Functions
        • Pattern Matching
        • Date Functions
        • Timestamp Functions
        • Timestamp With Time Zone Functions
        • Time Functions
        • Interval Functions
        • Date Formats
        • Date Parts
        • Blob Functions
        • Nested Functions
        • Utility Functions
      • Indexes
      • Aggregates
      • Window Functions
      • Samples
      • Information Schema
      • Configuration
      • Pragmas
    • Extensions
      • Overview
      • Full Text Search
      • JSON
      • HTTPFS
      • SQLite Scanner
      • Postgres Scanner
      • Substrait
  • Development
    • Testing
      • Overview
      • SQLLogicTest
      • Debugging
      • Result Verification
      • Persistent
      • Loops
      • Multiple Connections
      • Catch
    • Internals Overview
    • Storage Versions & Format
    • Execution Format
    • Profiling
    • Release Dates
    • Building
  • Sitemap
  • Why DuckDB
  • Media
  • FAQ
  • Code of Conduct
  • Live Demo
Search
Page Source
Version 0.6.1
Version:
  • dev
  • 0.9.0
  • 0.8.1
  • 0.7.1
  • 0.6.1
Search Shortcut cmd + k | ctrl + k