DISTINCT

Deduplicates rows united by multiple aliases.

• Expression: DISTINCT alias1, alias2, ...

Comman Usage

Example: Direct deduplicate

UQL
uncollect [1,2,1,2] as a
uncollect [3,4,5,4] as b
return distinct a, b

Result-a
1
2
1

Result-b
3
4
5

Example: Multiply and deduplicate

UQL
uncollect [1,2,1,2] as a
uncollect [3,4,5,4] as b
with distinct a, b
return a, b

Result-a
1
1
1
2
2
2

Result-b
3
4
5
3
4
5