Re: get distinct values

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Sun, 14 Mar 2010 10:50:46 +0100
Message-ID: <4b9cb176$0$22919$e4fe514c_at_news.xs4all.nl>

Op 13-3-2010 0:42, John Hurley schreef:
> On Mar 12, 4:58 pm, webtourist<webtour..._at_gmail.com> wrote:
>
> snip
>
>> How can I get result like this: (distinct names in "job_list") ?
>>
>> DEPTNO JOB_LIST
>> ------ ----------------------------------------------------
>> 10 CLERK MANAGER PRESIDENT
>> 20 ANALYST CLERK MANAGER
>> 30 CLERK MANAGER SALESMAN
>
> Are you running 7.3.4?

Was xmlagg in that version?

Shakespeare Received on Sun Mar 14 2010 - 04:50:46 CDT