I need a function for calculating combinations without repetition from a list.
Example:
I have a list of names e.g.
Tom
Bob
Paul
Tina
Now I need a list of 3 names out of the 4 without having a name twice and without having the 3 names twice because of ordering. The correct result would be
Tom,Bob,Paul
Tom,Paul,Tina
Tom,Bob,Tina
Bob,Paul,Tina
Of course this also should work quite fast with 14 out of 19 or similar.
Best Answer
You can use regular joins: