SQL to return certain number of a column values concat to each other?
From: <adamvt_at_my-deja.com>
Date: Fri, 22 Sep 2000 20:14:44 GMT
Message-ID: <8qgej1$o5k$1_at_nnrp1.deja.com>
10
5160
129
230
515
4000
2398
456
239
.
.
And now I wanna create a view based on this table where I'll be able to [Quoted] get something like:
10 5160 129
230 515 4000
2398 456 239
.
.
which concats every three values together. Is this possible? if so could you provide an example?
Thanks in advance!
Adam Tadj
Date: Fri, 22 Sep 2000 20:14:44 GMT
Message-ID: <8qgej1$o5k$1_at_nnrp1.deja.com>
[Quoted] [Quoted] I wonder if this is possible with SQL? Say I have a table and if I SELECT column of it I get:
SELECT a_col FROM a_tab;
a_col
10
5160
129
230
515
4000
2398
456
239
.
.
And now I wanna create a view based on this table where I'll be able to [Quoted] get something like:
SELECT a_conc_col FROM a_view;
a_conc_col
10 5160 129
230 515 4000
2398 456 239
.
.
which concats every three values together. Is this possible? if so could you provide an example?
Thanks in advance!
Adam Tadj
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Sep 22 2000 - 22:14:44 CEST