mirror of
https://github.com/ClickHouse/ClickHouse.git
synced 2026-10-28 16:18:23 +08:00
56 lines
1.2 KiB
Plaintext
56 lines
1.2 KiB
Plaintext
---
|
|
description: 'Return an intersection of given arrays (Return all items of arrays,
|
|
that are in all given arrays).'
|
|
slug: /sql-reference/aggregate-functions/reference/grouparrayintersect
|
|
title: 'groupArrayIntersect'
|
|
doc_type: 'reference'
|
|
---
|
|
|
|
{/*AUTOGENERATED_START*/}
|
|
## groupArrayIntersect {#groupArrayIntersect}
|
|
|
|
Introduced in: v24.2.0
|
|
|
|
Return an intersection of given arrays (Return all items of arrays, that are in all given arrays).
|
|
|
|
|
|
**Syntax**
|
|
|
|
```sql
|
|
groupArrayIntersect(x)
|
|
```
|
|
|
|
**Arguments**
|
|
|
|
- `x` — Argument (column name or expression). [`Any`](/reference/data-types/index)
|
|
|
|
**Returned value**
|
|
|
|
Returns an array that contains elements that are in all arrays. [`Array`](/reference/data-types/array)
|
|
|
|
**Examples**
|
|
|
|
**Usage example**
|
|
|
|
```sql title=Query
|
|
-- Create table with Memory engine
|
|
CREATE TABLE numbers (
|
|
a Array(Int32)
|
|
) ENGINE = Memory;
|
|
|
|
-- Insert sample data
|
|
INSERT INTO numbers VALUES
|
|
([1,2,4]),
|
|
([1,5,2,8,-1,0]),
|
|
([1,5,7,5,8,2]);
|
|
|
|
SELECT groupArrayIntersect(a) AS intersection FROM numbers;
|
|
```
|
|
|
|
```response title=Response
|
|
┌─intersection─┐
|
|
│ [1,2] │
|
|
└──────────────┘
|
|
```
|
|
{/*AUTOGENERATED_END*/}
|