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