I have a table that looks something like and I would like to create all possible combinations with the sum of the prices, including the unique values to create something like what would be the quick and dirtiest way of accomplishing this? Answer Use three joins:
Tag: permutation
Get the all unique permutation and combinations of ‘where clause conditions’ for my table in SQL Server
I would like to see all possible unique scenarios of my data in a table. I can give the Input like Operators=[<,>,=,……] Operands=[mode, StartDate,EndDate,…..] I am expecting the result like 0 and 1/1/2018<1/12/2018 0 and 1/1/2020=1/1/2020 1 and 1/1/2018>5/5/2015 1 and 3/8/2015<1/12/2019 1 and 19/11/1992=19/11/1992 these are my unique patterns in my data. So is there any query or java