Re: is concat a group by function?

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 Fri May 04 2001 - 22:19:29 CDT