SQL help

[Popkatapetapotapulti]

How to get all combinations of a column values using recursive cte cheste values like (26, 2), (26,1) etc are missed which I think is ignoring repetition as we already have (1,26)

Example:

Col:

1

2

26

 

output:

1

2

26

1,2

1,26

1,2,26

1,26,2

2,26

2,1

2,26,1

2,1,26

26,2

26,1

26,1,2

26,2,1

 

[Novak_Djokovic]

ltt...

[Novak_Djokovic]

post your query here...

[mtkr]

ltt

[manchiivaadu]

@Popkatapetapotapulti first nee id ki meaning chepu

[kiraak_poradu]

1 minute ago, manchiivaadu said:

@Popkatapetapotapulti first nee id ki meaning chepu

Popu pettinanka peta la petti pulti kottindu gantha ne 

[Popkatapetapotapulti]

2 hours ago, Novak_Djokovic said:

post your query here...

got it working by slightly tweaking my query 

thanks for ltt

[Popkatapetapotapulti]

1 hour ago, manchiivaadu said:

@Popkatapetapotapulti first nee id ki meaning chepu

On 5/22/2017 at 5:29 PM, Popkatapetapotapulti said:

who is she? whats her name?

i think i love her 

click on top right of my post..find out who is she.. then I will tell 

 

[Novak_Djokovic]

2 minutes ago, Popkatapetapotapulti said:

got it working by slightly tweaking my query 

thanks for ltt

Welcome to afdb....

[kingcasanova]

left leg forward right leg backward