Re: is concat a group by function?
From: (wrong string) é Gamache <andre.gamache_at_sympatico.ca>
Date: Fri, 04 May 2001 23:19:29 -0400
Message-ID: <3AF37141.68C0FE57_at_sympatico.ca>
Date: Fri, 04 May 2001 23:19:29 -0400
Message-ID: <3AF37141.68C0FE57_at_sympatico.ca>
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?
Received on Sat May 05 2001 - 05:19:29 CEST