alrenative recursive function

Database
Enthusiast

alrenative recursive function

Concatinating the 2 row values in one row.

Id

Id1

 

Output :

Id,Id1

is there any easy way without using recursive function or if we use recursive function can we create sql logic in one  single table.