Re: Collect function
From: Dan Blum <tool_at_panix.com>
Date: Wed, 16 Sep 2009 19:22:27 +0000 (UTC)
Message-ID: <h8rdtj$e66$1_at_reader1.panix.com>
Sashi <smalladi_at_gmail.com> 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:
Date: Wed, 16 Sep 2009 19:22:27 +0000 (UTC)
Message-ID: <h8rdtj$e66$1_at_reader1.panix.com>
Sashi <smalladi_at_gmail.com> 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 tool_at_panix.com "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