Re: Concat a column?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 14 Sep 2009 20:51:48 +0200
Message-ID: <4aae90c3$0$414$426a74cc_at_news.free.fr>


"Sashi" <smalladi_at_gmail.com> a écrit dans le message de news: 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

Search for stragg on AskTom site.

Regards
Michel Received on Mon Sep 14 2009 - 13:51:48 CDT

Original text of this message