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:

> 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

Original text of this message