Hello, I have a table with column values like below in an SQL server database. Values A B C I need output like below Output a,b,c a,c,b b,c,a b,a,c c,a,b c,b,a Can some one please check and help me to provide the solution?

test this Method 1. select distinct t1.Col1, t2.Col1 from MyTable t1, MyTable t2 method 2. SELECT a.Col1, b.Col1 FROM MyTable a CROSS JOIN MyTable b

Thanks Sachin for checking this. It works for specific number of rows. But the number of values in the table can be changed. i got the solution from the below link https://stackoverflow.com/questions/3621494/the-most-elegant-way-to-generate-permutations-in-sql-server