SQL Query for returning all the possible combinations of a column

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