Re: Collect function

From: Dan Blum <>
Date: Wed, 16 Sep 2009 19:22:27 +0000 (UTC)
Message-ID: <h8rdtj$e66$>

Sashi <> wrote:
> HI all, I'm trying to use the collect() function (mentioned in my
> earlier post in this ng) but it, well, collects all values. Is there
> any way of avoiding duplicates?
> What I'm trying to do is this:

> select collect(a1), a2, a3, a4
> from A
> group by a2, a3, a4.

select collect(distinct a1)... should work.

Dan Blum					
"I wouldn't have believed it myself if I hadn't just made it up."
Received on Wed Sep 16 2009 - 14:22:27 CDT

Original text of this message