Use cases
Developers
Data publishers
Documentation
Pricing
Open
tap
Use cases
Developers
Data publishers
Documentation
Pricing
Open
tap
What is tap?
Concepts
Files
Data
Models
APIs
Domains
API keys
Storage
SQL Reference
SELECT syntax
WITH clause
SELECT clause
FROM clause
WHERE clause
JOIN clause
GROUP BY clause
HAVING clause
UNION clause
ORDER BY clause
LIMIT clause
EXCLUDE and EXCEPT clause
Subqueries
Subquery operators
SELECT clause subqueries
FROM clause subqueries
WHERE clause subqueries
HAVING clause subqueries
Subquery categories
Data Types
Character Types
Numeric Types
Date/Time Types
Boolean Types
Binary Types
Unsupported SQL Types
Supported Arrow Types
Operators and Literals
Numerical Operators
Comparison Operators
Logical Operators
Bitwise Operators
Other Operators
Literals
Aggregate Functions
General Functions
Statistical Functions
Approximate Functions
Window Functions
Syntax
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
SQL Reference
SELECT syntax
WITH clause
SELECT clause
FROM clause
WHERE clause
JOIN clause
GROUP BY clause
HAVING clause
UNION clause
ORDER BY clause
LIMIT clause
EXCLUDE and EXCEPT clause
Subqueries
Subquery operators
SELECT clause subqueries
FROM clause subqueries
WHERE clause subqueries
HAVING clause subqueries
Subquery categories
Data Types
Character Types
Numeric Types
Date/Time Types
Boolean Types
Binary Types
Unsupported SQL Types
Supported Arrow Types
Operators and Literals
Numerical Operators
Comparison Operators
Logical Operators
Bitwise Operators
Other Operators
Literals
Aggregate Functions
General Functions
Statistical Functions
Approximate Functions
Window Functions
Syntax
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