Re: is concat a group by function?

From: Carlos Bromanski <cbroman_at_shpamcore.com>
Date: Fri, 4 May 2001 19:36:15 -0500
Message-ID: <3af34a5d$0$14444$1dc6e903_at_news.corecomm.net>

Do what? Please describe what result you're trying to get. CONCAT is not an aggregate function. (not in Chicago, anyway) -cb

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 - 02:36:15 CEST

This message: [ Message body ]
Next message: ⡷牯湧⁳瑲楮朩⃩⁇慭慣桥: "Re: is concat a group by function?"
Previous message: Lee Fesperman: "Re: S.O.D.A. database Query API - call for comments"
In reply to: Aloha Kakuikanu: "is concat a group by function?"
Next in thread: ⡷牯湧⁳瑲楮朩⃩⁇慭慣桥: "Re: is concat a group by function?"
Reply: Aloha Kakuikanu: "Re: is concat a group by function?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message