Message-ID: <3AF37141.68C0FE57@sympatico.ca>
From: André Gamache <andre.gamache@sympatico.ca>
X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.theory
Subject: Re: is concat a group by function?
References: <%zFI6.1690$vg1.141759@www.newsranger.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Lines: 23
Date: Fri, 04 May 2001 23:19:29 -0400
NNTP-Posting-Host: 64.231.196.141
X-Complaints-To: abuse@sympatico.ca
X-Trace: news20.bellglobal.com 989032223 64.231.196.141 (Fri, 04 May 2001 23:10:23 EDT)
NNTP-Posting-Date: Fri, 04 May 2001 23:10:23 EDT


Hi :

Why not making a sort instead of a grouping.
SELECT
MGR,
CONCAT( EMPNO ) || ','
FROM SCOTT.EMP
ORDER BY MGR

André



Aloha Kakuikanu wrote:

> SELECT
> MGR,
> CONCAT( EMPNO ) || ','
> FROM SCOTT.EMP
> group by MGR
>
> doesn't work, of course. Any other way to do it?