rows to string conversion
911800Mar 5 2012 — edited Mar 6 2012Hii..Experts,
I have a big problem in SQL..
Plz help me to solve the Query.
Let's I have a table 'table1' having columns A,B,C,D,E, and my table structure is like this.
A B C D E
1 4 1 4 1
2 5 2 5 2
3 6 3 6 3
I want to show the result like this: 1 4 1 4 1 2 5 2 5 2 3 6 3 6 3. i.e all values in one row and with out using concatenation operator..
What will be the SQL QUERY???( Not using concatenation operator).
Regards
Soumya.