SQL Reference

• Data Types
  • Character Types
  • Numeric Types
  • Date/Time Types
  • Boolean Types
  • Binary Types
  • Unsupported SQL Types
  • Supported Arrow Types
• SELECT syntax
  • WITH clause
  • SELECT clause
  • FROM clause
  • WHERE clause
  • JOIN clause
  • GROUP BY clause
  • HAVING clause
  • QUALIFY clause
  • UNION clause
  • ORDER BY clause
  • LIMIT clause
  • EXCLUDE and EXCEPT clause
  • Pipe operators
• Subqueries
  • Subquery operators
  • SELECT clause subqueries
  • FROM clause subqueries
  • WHERE clause subqueries
  • HAVING clause subqueries
  • Subquery categories
• DDL
  • CREATE DATABASE
  • CREATE SCHEMA
  • CREATE EXTERNAL TABLE
  • CREATE TABLE
  • DROP TABLE
  • CREATE VIEW
  • DROP VIEW
  • DESCRIBE
• DML
  • COPY
  • INSERT
• EXPLAIN
  • Syntax
  • EXPLAIN
  • EXPLAIN ANALYZE
• Information Schema
  • SHOW TABLES
  • SHOW COLUMNS
  • SHOW ALL (configuration options)
  • SHOW FUNCTIONS
• Operators and Literals
  • Numerical Operators
  • Comparison Operators
  • Logical Operators
  • Bitwise Operators
  • Other Operators
  • Literals
• Aggregate Functions
  • Filter clause
  • General Functions
  • Statistical Functions
  • Approximate Functions
• Window Functions
  • Syntax
  • Filter clause for aggregate window functions
  • Aggregate functions
  • Ranking Functions
  • Analytical Functions
• Scalar Functions
  • Math Functions
  • Conditional Functions
  • String Functions
  • Binary String Functions
  • Regular Expression Functions
  • Time and Date Functions
  • Array Functions
  • Struct Functions
  • Map Functions
  • Hashing Functions
  • Union Functions
  • Other Functions
• Special Functions
  • Expansion Functions
• Format Options
  • Specifying Options and Order of Precedence
• Available Options
  • JSON Format Options
  • CSV Format Options
  • Parquet Format Options
• Prepared Statements
  • Inferred Types
  • Positional Arguments

previous

Expression API

next

Data Types