Concat a column?
From: Sashi <smalladi_at_gmail.com>
Date: Mon, 14 Sep 2009 11:33:25 -0700 (PDT)
Message-ID: <c18a563e-94cf-4f35-8c96-df4d40105802_at_j19g2000vbp.googlegroups.com>
Hi All, I'm looking to concatenate multiple values for a single column and am wondering if this is possible.
Date: Mon, 14 Sep 2009 11:33:25 -0700 (PDT)
Message-ID: <c18a563e-94cf-4f35-8c96-df4d40105802_at_j19g2000vbp.googlegroups.com>
Hi All, I'm looking to concatenate multiple values for a single column and am wondering if this is possible.
select concat(a1), a2, a3, a4
from A
group by a2,a3,a4
The above will select multiple values of a1. These could range between
one value to 10 or 12.
I'd like to have them all concatenated, while retaining distinct
values of a2,a3 and a4.
Is this possible?
TIA,
Sashi
Received on Mon Sep 14 2009 - 13:33:25 CDT