How to Generate Permutations in SQL
Posted on 2014-07-23
I have 8 categories - A, B, C, D, E, F, G & H.
I want to create groups that reflect every single combination of these categories without there being duplicates. Is this even possible. I am obliged to think, but i am not sure how. Any assistance from the experts will be greatly appreciated. The groups would look like followings:
C, D . . . etc.