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_at_www.newsranger.com>
Date: Sat, 05 May 2001 01:09:26 GMT
Message-ID: <apII6.1856$vg1.154296_at_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 Sat May 05 2001 - 03:09:26 CEST