I tried grouping using that column. But it does not support more than 4086 combinations.

ill try this out, getnums ? a tally table?

I have data in a column.

Want to make all the possible combinations.

You have given the idea that group by cube will do that,

And have i have to pass arguments which...

thank u bro

Thank u bro.. Will give a try..

Hope have learnt how to post 😉

group by clause cube function does it for column names.

but the requirement is on rows of column, so what i did, pivoted the table rows in to columns which is...

Thank you sir, this creates sets for columns.

I.e if there are three columns its produces set for columns.

I need all the possible sets for rows in the column.that can be...

Thank you sir, this creates sets for columns.

I.e if there are three columns its produces set for columns.

I need all the possible sets for rows in the column.that can be...

its about metal melting ,

there will be metal scraps with different purtiy,

for example , metal1 weight of 5kg will be 70% purity,

metal2 weight of 3kg will be 80%...

Attributes X Y Z

Material a. 100...

There are several materials with 3 attributes .

Requirement will be for attributes with specific value ranges,

That may not be available with a single material. So can combine 2...

The reason is,

I have a record with 3 columns of values.

I need Specific value that comes when combining some records , so that i can enter the value which...

The reason is,

I have a record with 3 columns of values.

I need Specific value that comes when combining some records , so that i can enter the value which...

The code does not works, goes not responsible for 13 rows itself didnt try .. That could be fine if it works for 30 rows at least

Can u tell me how to get then?