Popkatapetapotapulti Posted May 23, 2017 Report Share Posted May 23, 2017 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 Quote Link to comment Share on other sites More sharing options...
Novak_Djokovic Posted May 23, 2017 Report Share Posted May 23, 2017 ltt... Quote Link to comment Share on other sites More sharing options...
Novak_Djokovic Posted May 23, 2017 Report Share Posted May 23, 2017 post your query here... Quote Link to comment Share on other sites More sharing options...
mtkr Posted May 23, 2017 Report Share Posted May 23, 2017 ltt Quote Link to comment Share on other sites More sharing options...
manchiivaadu Posted May 23, 2017 Report Share Posted May 23, 2017 @Popkatapetapotapulti first nee id ki meaning chepu Quote Link to comment Share on other sites More sharing options...
kiraak_poradu Posted May 23, 2017 Report Share Posted May 23, 2017 1 minute ago, manchiivaadu said: @Popkatapetapotapulti first nee id ki meaning chepu Popu pettinanka peta la petti pulti kottindu gantha ne Quote Link to comment Share on other sites More sharing options...
Popkatapetapotapulti Posted May 24, 2017 Author Report Share Posted May 24, 2017 2 hours ago, Novak_Djokovic said: post your query here... got it working by slightly tweaking my query thanks for ltt Quote Link to comment Share on other sites More sharing options...
Popkatapetapotapulti Posted May 24, 2017 Author Report Share Posted May 24, 2017 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 Quote Link to comment Share on other sites More sharing options...
Novak_Djokovic Posted May 24, 2017 Report Share Posted May 24, 2017 2 minutes ago, Popkatapetapotapulti said: got it working by slightly tweaking my query thanks for ltt Welcome to afdb.... Quote Link to comment Share on other sites More sharing options...
kingcasanova Posted May 24, 2017 Report Share Posted May 24, 2017 left leg forward right leg backward Quote Link to comment Share on other sites More sharing options...
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.