Firebolt Documentation home page
Search...
⌘K
Ask AI
Contact us
Book a demo
Book a demo
Search...
Navigation
Array functions
Array functions
Documentation
Firebolt Core
📰 Blog
What is Firebolt?
Overview
Platform capabilities
Overview
Overview
Architecture
Pricing and billing
Organizations and accounts
Engine Fundamentals
Data modeling
Data management
Queries
Table and Column Compression
Security
Guides
Run queries
Manage organization
Get started
Operate Engines
SQL Dialect
Load data
Export data
Configure security
Develop with Firebolt
Integrate with Firebolt
Migrate to Firebolt
SQL reference
Overview
Data types
Information schema
Operators
SQL commands
SQL functions
Overview
Functions glossary
Aggregation functions
Array functions
Overview
ARRAY_CONCAT
ARRAY_CONTAINS
ARRAY_COUNT_DISTINCT
ARRAY_COUNT
ARRAY_DISTINCT
ARRAY_INTERSECT
ARRAY_LENGTH
ARRAY_MAX
ARRAY_MIN
ARRAY_REVERSE_SORT
ARRAY_REVERSE
ARRAY_SLICE
ARRAY_SORT
ARRAY_SUM
ARRAY_TO_STRING
ARRAYS_OVERLAP
ARRAY_FLATTEN
INDEX_OF
Binary functions
Conditional and miscellaneous functions
DataSketches functions
Date and time functions
Geospatial functions
JSON functions
Lambda functions
Numeric functions
Session functions
String functions
Table-valued functions
Vector functions
Window functions
General reference
Overview
Release notes
Available regions
System settings
Object identifers
Reserved words
Arithmetic with intervals
Help menu
API reference
Overview
Synchronous queries
Asynchronous queries
On this page
Array functions
Array functions
Array functions
Reference for array functions
Array functions
Assistant
Responses are generated using AI and may contain mistakes.
VAR_SAMP
ARRAY_CONCAT