Re: [sqlite] How to concat column

On Fri, Jul 9, 2010 at 2:35 PM, Peng Yu wrote: > On Sun, Jul 4, 2010 at 7:15 PM, P Kishor wrote: >> On Sun, Jul 4, 2010 at 6:15 PM, Peng Yu wrote: >>> Hi, >>> >>> I only find row-wise concatenation by not column-wise. >>> >>> For example, I have table >>> >>> x1 y1 >>> x1 y2 >>> x2 y3 >>> x4 y4

Re: [sqlite] How to concat column

On Sun, Jul 4, 2010 at 7:15 PM, P Kishor wrote: > On Sun, Jul 4, 2010 at 6:15 PM, Peng Yu wrote: >> Hi, >> >> I only find row-wise concatenation by not column-wise. >> >> For example, I have table >> >> x1 y1 >> x1 y2 >> x2 y3 >> x4 y4 >> >> I want to have the second column concatenated based on

Re: [sqlite] How to concat column

On Sun, Jul 4, 2010 at 6:15 PM, Peng Yu wrote: > Hi, > > I only find row-wise concatenation by not column-wise. > > For example, I have table > > x1 y1 > x1 y2 > x2 y3 > x4 y4 > > I want to have the second column concatenated based on the value in > the first column to get the new table > x1 y1y2

[sqlite] How to concat column

Hi, I only find row-wise concatenation by not column-wise. For example, I have table x1 y1 x1 y2 x2 y3 x4 y4 I want to have the second column concatenated based on the value in the first column to get the new table x1 y1y2 x2 y3y4 Moreover, I want to have a spectator (e.g., ',') in the second