Collect function

From: Sashi <smalladi_at_gmail.com>
Date: Tue, 15 Sep 2009 19:47:17 -0700 (PDT)
Message-ID: <3ee9f014-288a-4aba-bba9-c1828fe8c3db_at_p15g2000vbl.googlegroups.com>

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.

Thanks,
Sashi Received on Tue Sep 15 2009 - 21:47:17 CDT