I want all the possible combination of a number in a given set of array.
I tried using some of the predefined functions of presto like array_agg(x)
Input : [1,2,3,4]
Output
when n=2 : [[1,2],[1,3],[1,4],[2,3],[2,4],[3,4]]
when n=3 : [[1,2,3],[1,2,4],[1,3,4],[2,3,4]]
when n=4 : [[1,2,3,4]] or [1,2,3,4]
There is combinations(array(T), n) function and it does exactly what you want:
select combinations(array[1,2,3,4],2);
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With