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.

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

Original text of this message