Re: is concat a group by function?

From: Aloha Kakuikanu <nospam_at_newsranger.com>
Date: Sat, 05 May 2001 01:09:26 GMT
Message-ID: <apII6.1856$vg1.154296@www.newsranger.com>

In article <3af34a5d$0$14444$1dc6e903_at_news.corecomm.net>, Carlos Bromanski says...
>
>Do what? Please describe what result you're trying to get.
>CONCAT is not an aggregate function. (not in Chicago, anyway)

The query is supposed to return:

MGR EMP
------ --------
Newton Gauss, Hilbert
Euclid Einstein

>Aloha Kakuikanu <nospam_at_newsranger.com> wrote in message
>news:%zFI6.1690$vg1.141759_at_www.newsranger.com...
>> SELECT
>> MGR,
>> CONCAT( EMPNO ) || ','
>> FROM SCOTT.EMP
>> group by MGR
>>
>> doesn't work, of course. Any other way to do it?
>>
>>
>>
>
>
Received on Fri May 04 2001 - 20:09:26 CDT